LinkBack URL
About LinkBacks
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
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
Last edited by avism; 08-12-2019 at 07:18 AM.
Formula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
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
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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.
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
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.
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?
If the concern is that the number of rows and/or columns may be changed put the row above the pivot table using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks