Hello,

I'm new with Qlik and i'm trying to create the Excel table you can see on the attached file. 

Column A is filter with some "Destination".

Column B is result for my month reference (YYYYMM)

Column C is result for one year ago (YYYYMM-1)

Column D  is result for three years ago (YYYYMM-3)

Column E is calculating the variation between month reference and one year ago (Col A- Col C/Col C)

Column F is calculating the variation between month reference and three year ago (Col A- Col D/Col D).

I've tried to do it with two different object "Pivot Table" and "P&L Pivot" with no success. 

Is there a way to do that easily ? 

Hope my explanations are clear ! Thanks for your help