Additional grand total to pivot with percent of grand total

[avism]

Hello,

I want to add second total row below grand total row.
The row will display for each column the % of pivot grand total.

How can I do it?

2222.jpg

Can you help me please delete my original post in "Excel General" forum?

Thank you

[avk]

=sum(b5*100)/$e5

[avism]

Hello,

Thank you for your help.
I need that it will be part of the pivot because the number of rows/columns are not fixed.
They may change in case of refresh/filtering.
I saw that there is a way to add grand total rows of sum/average/count but not percent of grand total.

Can you help me?

Thank you

[AliGW]

FYI - to get a thread moved in future, contact a moderator or an administrator. Do NOT attempt to do it yourself by opening new threads.

As you have a response here, I have closed the earlier thread.

[AliGW]

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[avism]

Hello,

Thank you.
I attached a sample workbook with Data sheet, current pivot sheet and required pivot.
I wish to add additional grand total row as part of the pivot and not by using formulas (marked in yellow in the sample workbook).

Thank you for your help

[avk]

Refer Attach file pivot sheet [row 5]
I have some modification in your data sheet. Insert table, Total & percentage column add & on top row sum of point.
On bottom not possible its nearest your requirement.

[avism]

Thank you very much for your help.

I think that if I will modify the data
in case of filtering the pivot the percent results will not be correct.

Can I solve it in a different way?

[JeteMc]

If the concern is that the number of rows and/or columns may be changed put the row above the pivot table using:

=IFERROR(IF(B4="Total Sum of Points",GETPIVOTDATA("Sum of Points",$A$3)/GETPIVOTDATA("Sum of Points",$A$3),GETPIVOTDATA("Sum of Points",$A$3,"Range",B4)/GETPIVOTDATA("Sum of Points",$A$3)),"")

Let us know if you have any questions.