Hello, everyone! I am very new to QlikView so I appreciate any help. I want to make pivot table which shows me Year, Month of sale, Seller name , Sum of sales, Sum of Sales in previous month. Something like that :
| Year and month of Sale | Seller Name | Monthly Sales | Previous month Sales |
| July 2013 | John | 200 | |
| Jim | 300 | |
| Bill | 150 | |
| August 2013 | John | 400 | 200 |
| Jim | 350 | 300 |
| Bill | 230 | 150 |
| September 2013 | John | 600 | 400 |
| Jim | 450 | 350 |
| Bill | 300 | 230 |
It is ok that for July we do not have sales for june - this does not concern me. What concerns me is that I do not know how to generate 'Previous month Sales' column. Please, could you help me?
Thanks in advance!
