Pivot Table - Current Period v Current Period (LY)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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😞

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.

topic Pivot Table - Current Period v Current Period (LY) in QlikView