Hello all,
I want to create a table that calculates the differnece in sales from week 1 to week 2 etc per product axis and make it either dynamic ( weeks appear as new data enter) or static.
My data are in this format. I have the Code, week number, the product axis and few metrics.
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/56383i596796FDCFDAA7DC/image-size/large?v=v2&px=999)
I wish to end up in a table to report as such:
![kstamab_0-1622967689011.png kstamab_0-1622967689011.png](https://community.qlik.com/t5/image/serverpage/image-id/56384i578D24E126BA691B/image-size/medium?v=v2&px=400)
where delta sales in week 2 is calculated as such: week 2 - week 1, for week 3: week 3 - week 2 and week 4: week 4 - week 3.
Is that possible to be achieved in Qlik Sense?
Any help is much appreciated!
PS. I have attached an excel file with the above data if that helps!