Pivot Table - Current Period v Current Period (LY)

[Anonymous]

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.