Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Present month and previous month difference

Hi All

I need difference on current cell as below

Requirement is

                    Jan-2012  Feb-2012  Mar-2012  Apr-2012   --- so on

Customer 1       0             -800           -320       110       ---------so on

Customer 2       0              520           -470      -1090     -------- so on

Meaning current month value - previous month value

I have attached test.qvw

I appreciate your suggestions

Thanks

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Expression: =Alt(sum(InvoiceValue) - before(total sum(InvoiceValue)), 0)

Turn off "Suppress Zero Values"

(tested on your model)

Capture.PNG

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi Jonathan

It's works. I appreciate your help.

Thanks