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

Distributing monthly values

I have sales values for Jan to Dec. February value is a summation of January and February, ....December value is a summation of all the 12 months values. I need to plot month by month actual value. Please help.

3 Replies
Gysbert_Wassenaar

Perhaps like this: Rangesum(Sum(Amount),Above(sum(Amount*-1)))


talk is cheap, supply exceeds demand
mogaka1234
Contributor
Contributor
Author

what *1?

Gysbert_Wassenaar

No, Amount*-1


talk is cheap, supply exceeds demand