Dynamic % Row within a Pivot Table

[moratufernando]

I have created a pivot table with a total row at the bottom as well as a total column at the right.
I need to create a "%" row at the bottom, below the total row, using the total of the individual column divided by the total of the total column.
Becuase there is a filter for the pivot table this percentage row needs to be dynamic as the number of both rows and columns will change when the filter is changed. Would welcome any advice on how to do this.
Thanks.

[dilipandey]

Hi moratufernando,

I would suggest you to include this row on top of the pivot table instead of bottom and use Subtotal function there. In case of any issue, upload a sample workbook. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

[moratufernando]

Thanks.
That is an option I had considered and can use.
However I was thinking of the following scenario.
The filter I was refering to in my original post is the "Year".
In the event I move the Year to the Pivot Table and have a subtotal for each year, would it be possible to get the percentage calculated for each yearly subtotal?
For this reason I was hoping to locate a solution that gives the reult within the Pivot table instead of outside.
If you have any suggestions to do it within the Pivot table, I am all ears.
Regards.

[dilipandey]

okay.. upload a small sample and mention you expected results.. let me give a try to this

Regards,
DILIPandey
<click on below * if this helps>

[moratufernando]

Thanks.
Will prepare an extract and upload shortly.
Please note VB is out of my league so any solution without VB would be preferred.
Regards.

[dilipandey]

Sure.. will try

Regards,
DILIPandey
<click on below * if this helps>

[MarvinP]

Hi,

Have you found this yet?

http://contextures.com/xlPivot10.html

[moratufernando]

Pivot % Row.xlsx

Dear Dilip
Please see Attached.
I am trying to get a "%" Row below each Annual Subtotal.

Thanks.

[moratufernando]

Sorry Marvin, I cannot access the link you sent me.
Thanks nonetheless.

[JosephP]

you can't have it showing just for the years (without an olap table anyway) but you can add the data field again and show it as a % of the entire column

[moratufernando]

Thanks for that. It does not exactly address my issue but was curious to get it going.
I added another column and set it as a "% Of" in the "Value Field Settings" box, "Show Values as" tab.
However in the "Base field" list, I do not see the "total" that is calculated in the pivot table. I only see the fields that are in the original database.

[moratufernando]

................

[JosephP]

use '% of column' not '% of' and another field

[moratufernando]

Thanks Joseph, I got it going.
Thanks Marvin, I did manage to get to Contextures.com and from there to Pierrefondes and found something quite useful.