Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

above() function

Hi - I have data as below

MonthSales
Jan100
feb200
March300

 

In the chart I wan to show increase on sales Month over Month.

So bar chart by Month and Jan will show 100, Feb will show 300 and March will show 600.

I TRIED ABOVE(SUM(SALES)) but this is not working.

Thank you for the help.

Labels (5)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this

 RangeSum(Above(sum(Sales), 0, RowNo()))

View solution in original post

2 Replies
Vegar
MVP
MVP

Try this

 RangeSum(Above(sum(Sales), 0, RowNo()))

apthansh
Creator
Creator
Author

You are awesome.Thank you.