RunningSum Breakby

[NoobieRhyme]

Help please with the Running Sum.

I have a "Product" & "Day" Attribute, and "Sales Count" & "Running Sales Count" Metric.

My Current Report displays the following:

Product Day Sales Count Running Sales Count
A 8/1/05 10 10
8/2/05 12 29
8/3/05 3 44
B 8/1/05 7 17
8/2/05 12 41
8/3/05 2 46

What I want to achieve is a result with a break by Product and Day.
The report should have the following values:

Product Day Sales Count Running Sales Count
A 8/1/05 10 10
8/2/05 12 22
8/3/05 3 25
B 8/1/05 7 7
8/2/05 12 19
8/3/05 2 21

I already set the Break-by and sort to Product and Day but
it still does not work. Any help please? Thanks

 

[spod]

You only want to break by Product. Sort order Product & Day.

 

[NoobieRhyme]

Thanks!

Is it possible to have a running total ignoring the filter?

Product Day Sales Count Running Sales Count
A 8/1/05 10 10
8/2/05 12 22
8/3/05 3 25
B 8/1/05 7 7
8/2/05 12 19
8/3/05 2 21

I want to filter the Day >= 8/2/05 and get the following result:

Product Day Sales Count Running Sales Count
A 8/2/05 12 22
8/3/05 3 25
B 8/2/05 12 19
8/3/05 2 21


How, please? Thanks!