Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
willianvbuss
Contributor II
Contributor II

Calculating current month balance divided by the previous month of the above range

I need help to do the calculation according to the attached image. In summary, I need to calculate the balance for a given range in the current month by the balance for the previous month in the range above.

Important: i need in a line chart, not in pivot table. In pivot table it's already done, using:

=sum(SomaSaldo)/above(Before(Sum(SomaSaldo),1,ColumnNo()))

But it's not working with the line chart.

 

Thanks.

exemple.JPG

0 Replies