Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Seems like the same thing you asked here:
Sunny,
This is working. But when I select a year like 2013 it seems like the logic breaks.
Any ideas?
Try this:
Aggr(RangeSum(Above(Sum({<Year, Vintage>}Revenue), 0, RowNo())), Vintage, Year)
and see if that helps
I agree with sunny's reply
please try his formula like ?
Aggr(RangeSum(Above(Sum{1}(Revenue), 0, RowNo())), Vintage, Year)
Alluraiah,
This is working correctly. But when I put this into a KPI object I am getting a Null.
Thanks,
Sunny,
This is working correctly. But when I put this into a KPI object I am getting a Null.
Thanks,
KPI shows a single value, what do you expect to see in your KPI?
try
Sum(Aggr(RangeSum(Above(Sum({<Year, Vintage>}Revenue), 0, RowNo())), Vintage, Year))
hope this helps
KPI shows a single value, what do you expect to see in your KPI?