Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My requirement is to get records of previous year when a particulat year is selected .
Sum of Sales
For the same, I have written the following code
sum({<CurrYear={$(=CurrYear-1)} >}Sales).
So if Curryear is selected as 2015 then i should sum up 2014 records. The formula is working fine when a particular year is selected.
BUt I have a chart where my Curryear is the dimension and my above formula is failing and returning 0.
Chart is Bar chart and the dimension is Curryear (2013,2014,2015, etc). For all years it is showing as 0
Can any one help on this problem? I think we need to change the set analysis, CurrYear = ???
BR,
Neehu
The set of a set analysis expression is calculated at the chart level, not at the row level. That's why your expression doesn't work with Curryear as dimension unless you select only one value in the Curryear dimension. You can try one of the approaches described in this document: Calculating rolling n-period totals, averages or other aggregations
The set of a set analysis expression is calculated at the chart level, not at the row level. That's why your expression doesn't work with Curryear as dimension unless you select only one value in the Curryear dimension. You can try one of the approaches described in this document: Calculating rolling n-period totals, averages or other aggregations
You cannot use a set expression like that. The set expression is calculated once for the chart/table and has no knowledge of the dimension values.