Peak Seagull
Member
Hi,
I’m hoping someone can help with my pivot table query (I am struggling with what to enter into a calculated field in the pivot table – if indeed you can).
I’ve attached a spreadsheet that shows some data generated from a data set into a Pivot Table (the attached is not the pivot table but just shows what is in the pivot table).
If it is possible, I would like to add some columns to my pivot table that do the following
Thanks a lot.
I’m hoping someone can help with my pivot table query (I am struggling with what to enter into a calculated field in the pivot table – if indeed you can).
I’ve attached a spreadsheet that shows some data generated from a data set into a Pivot Table (the attached is not the pivot table but just shows what is in the pivot table).
If it is possible, I would like to add some columns to my pivot table that do the following
- Show a column for the Accumulative Revenue i.e. adding the May revenue to the previous months revenue and so on (although the April figure in each year should remain the same as the figure in the Total Revenue column as that is the starting point in each year).
- Another column for Accumulative Target – this would be 50% of the previous years total divided by 12 and shown as a monthly accumulative target.
- A final column showing the % difference between actual and target.
Thanks a lot.