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.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Greg Truby

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

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,724
Members
410,702
Latest member
clizama18
Top