Hi Qlikers,
I am quite new to QV and would appreciate assistance. I currently have a pivot table with the following as dimensions:-
- CustomerName
- ProductCategory
- ProductBrand
- ProductDescript
My expressions (or what I would like to achieve, rather) are:
- Actual :sum(QtyTotal)
- LY (Last Year): This should be the value of Actual but exactly one year ago
I have arranged my table as in the following (with sample data and dimensions in bold, expressions in italics😞
| Year | 2016 | 2017 |
Quarter | | |
Month | | |
CustomerName | ProductCategory | ProductBrand | ProductDescript | Actual | Last Year | Actual | Last Year |
CustA | RTD | Johnny Bow | Johnny Bow & Vodka | 22169 | | 33164 | |
CustB | RTD | Johnny Bow | Johnny Bow & Gin | 15223 | | 13222 | |
My question is how do I get the previous year sums to show in the Last Year column? Or would there be another simpler approach?
Thanks in advance.