Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hello
could you post a piece of data and the formulas you used in your graph ?
Heading used in above table is the expressions formula used
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))
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.