Cumulative Sales for Products over multiple years

[jeckstein]

Hi.

I have a table that shows Year,Product, and Sales. I need to create a cumulative sales column for each product by different Years.

I need to create set analysis to create the "Cumulative Sales" Column. I have included the equations for cumulative sales in the "Cumulative Sales Equation".

Thanks in advance

[sunny_talwar]

Seems like the same thing you asked here:

cummulative sales set analysis

[jeckstein]

Sunny,

This is working. But when I select a year like 2013 it seems like the logic breaks.

Any ideas?

[sunny_talwar]

Try this:

Aggr(RangeSum(Above(Sum({<Year, Vintage>}Revenue), 0, RowNo())), Vintage, Year)

and see if that helps

[Anonymous]

I agree with  sunny's reply

please try his formula like ?

Aggr(RangeSum(Above(Sum{1}(Revenue), 0, RowNo())), Vintage, Year)

[jeckstein]

Alluraiah,

This is working correctly. But when I put this into a KPI object I am getting a Null.

Thanks,

[jeckstein]

Sunny,

This is working correctly. But when I put this into a KPI object I am getting a Null.

Thanks,

[sunny_talwar]

KPI shows a single value, what do you expect to see in your KPI?

[Frank_Hartmann]

try

Sum(Aggr(RangeSum(Above(Sum({<Year, Vintage>}Revenue), 0, RowNo())), Vintage, Year))

hope this helps

[sunny_talwar]

KPI shows a single value, what do you expect to see in your KPI?