0

Subtotaling Problem

Jet Reports Historic Posts

June 10, 2009 20:20

None

Follow

Hello again,
I am having a hard time Subtotaling my Sales $ at every change in Parent. I can do this after the report is run but is there anyway to group and subtotal before the report is run? Please help! Thanks!!
Please see attached.

• Jet Template Com.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts June 10, 2009 22:35 Official comment

  Hello,
  
  I took a look at the report and I think that I have a solution to what you are looking for. I changed the NL("Rows") that is listing out the Parents to NL("Rows=4") and then used an Excel SUBTOTAL function to get totals for everything. Take a look at the attached report and let me know if this seems to have fixed the issue.

  • Jet Template Com Revised.xlsx
• 0
  
  Jet Reports Historic Posts June 11, 2009 12:20

  Hello,
  Thanks for your reply. I think that is a start but the subtotals for each parent is coming to zero (its not getting the amounts from top to bottom). I think its just calculating the subtotal for the line above it? Any ideas why? Thanks again!

• 0
  
  Jet Reports Historic Posts June 11, 2009 12:22

  Nevermind..I entered the formula in incorrectly but now its perfect! Thanks so much for you help!