Pivot table question

alexis — Tue, 11 Sep 2018 09:39:06 GMT

I have the following pivot table and have a couple of requirements which I am struggling with:

a) For the YEARS I only want the last 2 years worth of data to show (i.e. 2017 and 2018 with this data set)

b) For each shop we need to see an extra row (after 2018 in this sample) that will show the difference between the 2 preceding years as a percentage (e.g. July/Nicosia it will be 1534-830 = +84%)

c) After the December column I would like to see 2 column totals:

i) YTD totals (for both years - in other words Jan-Sep for both 2018 and 2017 - see my YTD and LYTD flags that I created in code

ii) Yearly "Total" for the whole row

d) Row totals:

- By Shop

- Grand Total

I would appreciate any assistance - attaching simplified application and data

Thanks

Alexis

topic Pivot table question in App Development

Pivot table question