Pivot Tables - Calculated Fields

Anne in Chicago

New Member
Joined
Sep 15, 2006
Messages
2
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.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,019
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

New Member
Joined
Sep 15, 2006
Messages
2
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

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,019
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,
 

Forum statistics

Threads
1,141,913
Messages
5,709,292
Members
421,625
Latest member
Natalie1107

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top