How do I add a comparison column - please refer sheet

Plymouth

New member
Joined
Oct 3, 2016
Messages
2
Reaction score
0
Points
0
Hi
How do I add a column to compare the difference in sales between fy 15 and fy14
I have attached a sheet showing the data set
Thanks in anticipation
 

Attachments

  • Excel Pivot Table example.xlsx
    16.1 KB · Views: 19
To achieve this you need to use calculated items
Select the item, say FY15
Click the Field Items Set button
Click "Calculated items"
Change the formula name if required
Select the FY field
Double click the first item FY15, say, then type the minus in the formula bar, then double click the second item, FY14, say.
Click OK and, presto you have a new field with the calculated item
 
Thank you for your assistance
It works a treat

Kind Regards
 
Back
Top