0

Subtotaling for each group

Jet Reports Historic Posts

July 23, 2012 05:35

None

Follow

Hello,

Can you guys help me how to solve my subtotaling in every group? because in my report I created a subtotal for each group by using the =SUBTOTAL(9,N14:N20) solution. But I think it gets the wrong subtotaling. please see attached file. I hope that you can help me solve this problem.

• MERCHANDISE REPORT.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 23, 2012 06:21

  new attachment - screen shot

  • SS.JPG
• 0
  
  Jet Reports Historic Posts July 23, 2012 15:10

  Hi,
  
  I believe your formula in H13 should be =NL("Rows=7". Currently you have Rows=8 which means that you do not have an anchor row below your replicator region. Does this fix the issue?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts July 24, 2012 00:31

  Hi,
  
  I believe your formula in H13 should be =NL("Rows=7". Currently you have Rows=8 which means that you do not have an anchor row below your replicator region. Does this fix the issue?
  
  Regards,
  Hughes

  
  
  yes! thank you!