# Pivot Tables - Calculated Fields

#### Anne in Chicago

##### New Member
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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
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?

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

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

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 ?

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,

Replies
7
Views
216
Replies
1
Views
585
Replies
0
Views
362
Replies
0
Views
53
Replies
2
Views
555

1,217,356
Messages
6,136,078
Members
449,988
Latest member
Mabbas

### 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.

### Which adblocker are you using?

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

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