Pivot Tables - Calculated Fields

[Anne in Chicago]

I have created a pivot table that has volume for this year and last year. I have added in two additional fields to show the % of Total or "share". Now I have 4 columns, TY, TY % of Total, LY, LY % of Total. How can I get a 5th column that would tell the difference between TY % of Total and LY % of Total?
Thanks.

 

[Greg Truby]

Welcome to the board. Can you post a wee bit of your source data (just a handful of rows is enough). You can use Erik's table-it or enclose the data in CODE tags. And then are your TY % and LY % true custom calculated fields as your thread title implies but you don't actually say in your post? Or are they created using the default pivot tools (using the Field Settings... dialog + Options button and picking % of ___ from the dropdown?

 

[Anne in Chicago]

They are not true calculated fields, I used the pivot tool % of Total option.
I do not know how to use the options you suggest. Will this work?

Raw Data
BRAND TY LY
CAPT MORGAN ORG 5375.487 4831.08
BACARDI SUPERIOR 2944.245 2621.91
PARAMOUNT WHITE 2009.956 1647.7
ADMIRAL NLSN SPD 1415.614 1096.92

Would like
Brand, TY, LY, Share TY, Share LY, Share Chg

 

[erik.van.geit]

seems like Greg missed your reply
I'm posting this reply, so you can check my signature for "Table-It", tool mentioned by Greg.
(I cannot help when it comes to PIVOTs, almost never need them in my applications)

Greg, still awake ?

 

[Greg Truby]

Anne,

I played with this quite a bit. And if there's a simple way of doing it within the pivot table, I'm not finding it. It looks like you'll just have to create the pivot first and then add in a helper column to calculate the change in percentage year-over-year.

Regards,