Above(sum(Sales) not working

[Anonymous]

Hi All,

I am using below chart

Month	Sales	sum(Sales)	Above(sum(Sales))
		150	-
Apr	40	40	-
Feb	20	20	-
Jan	10	10	-
Mar	30	30	-
May	50	50	-

Why Above(sum(sales)) is not working here

[olivierrobin]

hello

could you post a piece of data and the formulas you used in your graph ?

[Anonymous]

Heading used in above table is the expressions formula used

[tresesco]

It seems that you have used Sales as a dimension. Either remove it from dimension, then the same expression would work. Otherwise, use the following expression: =Above(total sum(sales))

[Anonymous]

Thanks Tresesco,

It is coming fine now .Idea was to find the cumulative sum . It is working fine if i am bringing month1 column only as below

month1	sum(Sales)	=if(rowno(TOTAL)=1,sum(Sales),RangeSum(Above(Sales,0,rowno(TOTAL))))
	150	0
1	10	10
2	20	30
3	30	60
4	40	100
5	50	150

But if i am bringing dimesnion Year as well then its not required result as above

Year	month1	sum(Sales)	=if(rowno(TOTAL)=1,sum(Sales),RangeSum(Above(Sales,0,rowno(TOTAL))))
		150	0
2012	1	10	10
2012	2	20	20
2012	3	30	30
2012	4	40	40
2012	5	50	50

Could you please tell me why its showing this behavior by adding a new dimension to the chart.