Ignore Dimensions in chart set analysis

[Anonymous]

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

[hic · Accepted solution]

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