Hello,
I've created a really tangled report and an the end I get up stuck with something apparently easy, but I can't see the problem…
D6 = Level 1 Grouping / by customer
D7 = Level 2 Grouping / by month
D8 = Rows / Production Order Amount
D9 = blank
D10 = TOTAL / month = AVERAGE(D8:D9) - working great
D11 = blank
D12 = TOTAL / customer =SUBTOTAL(9;D10:D11) - not working…
So, for D12 I would need to sum up all the monthly averages.
Thanks,
Elena
Date
Votes
6 comments
-
Jet Reports Historic Posts Official comment Aaah I see your problem now. One way to solve this would be to put the AVERAGE and SUBTOTAL functions into a different column. Then the values from D8 and D9 would not be summed. If you really want the values to appear in column D, you could just reference the values in the other column and hide that column. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Elena,
It looks like the problem is that your SUBTOTAL function needs to include the actual replicator rows, not just the AVERAGE function. So possibly it needs to be =SUBTOTAL(9;D8:D11) or something like this. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Tried your proposal but it sums my values + my average, like this:
D8 = Row 1 = 30
D9 = Row 2 = 40
D10 = blank
D11 = AVERAGE(D8:D10) = 35
D12 = blank
D13 = SUBTOTAL(9;D8:D12) - 105 (it shoud be 35)
Any other idea?
Thanks,
Elena -
Jet Reports Historic Posts Yes, that should work. Nice trick :)
Thanks,
Elena -
Jet Reports Historic Posts Or try using:
D11 = SUBTOTAL(1;D8:D10) -
Jet Reports Historic Posts Hi Sebastiaan,
Out of curiosity I tried your suggestion (the report has already been delivered) and it works great!
Thanks,
Elena
Please sign in to leave a comment.