Resetting a Running Total on Multiple Group Change

[mirogak]

Hi guys,

I have an easy question:

I am using a Running Total but I want it to reset on the change of not one group but multiple groups (Product_Type, Year, and Month). How do I show in the x-2 (Use a formula) option of the Running Totals window, that it should reset when 3 groups change.

Appreciate your help.

Mirogak

 

[lbass]

Since groups are nested, you just need to use the innermost group for the reset. If you are saying you want results for three different group levels, this will require three separate running totals, each with the reset for the specific group.

-LB

 

[mirogak]

Thank you bass ... that worked.