Running Totals in Groups

[MatthiasU]

Hi,

how can I achieve the following behavior of Running Totals?

My report is grouped in multiple levels: Cat, Subcat, Detail. I need a running total within the Cat Level for all Subcat and Detail instances. For example (last column)

Cat A
SubCat A1
Detail 1 500 500
Detail 2 200 700
Total SubCat A1 700 700

SubCat A2
Detail 3 150 850
Total SubCat A2 150 850
Total CatA 850 850

Cat B
SubCat B1
Detail 4 300 300
Detail 5 100 400
Total SubCat A1 400 400

SubCat B2
Detail 6 550 550
Total SubCat B2 550 950
Total CatB 950 1800


So, running total for subcategories and details should be restarting within each Category.


Many thanks & Regards,
Matthias

[Lech Kulikowski]

Hello,

Please send us a test data, we will try to find and prepare a solution for you.

Thank you.

[MatthiasU]

Hi,

please see attachement for sample report with data and screenshot with current and expected output.


Many thanks & Regards,
Matthias

[Lech Kulikowski]

Hello,

Please check the modified report in the attachment.

Thank you.

[MatthiasU]

Hello,

OK, thanks. Not really a nice solution


Many thanks & Regards,
Matthias

[Lech Kulikowski]

Hello

Please let us know if you need any additional help.

Thank you.