Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day ,
I have a straight table with thse figures:
dimension : Month
expression count(ID)
Chart 1:
Month | Total |
---|---|
Jan | 10 |
Feb | 12 |
Mar | 14 |
Now i want to ignore the Dimension using set analysis
so that my end result is like this :
Month | PrevMonTotal |
---|---|
Jan | 0 |
Feb | 10 |
Mar | 12 |
Apr | 14 |
thanx in advance
The Set Analysis is global for the chart - i.e. it is not evaluated row-by-row. The best way to solve this problem is to use
RangeSum(Above(Count(ID)))
Then you get the value from previous row.
HIC
The Set Analysis is global for the chart - i.e. it is not evaluated row-by-row. The best way to solve this problem is to use
RangeSum(Above(Count(ID)))
Then you get the value from previous row.
HIC