Pivot Table Filter - Without changing Grand Total

[Nuno W]

Hello,

I have created a pivot table and naturally there will be a Grand Total at the bottom of it.In the Data part of the table, there are two columns. The second is the exact same field than the first one but expressed as percentage.
I applied a filter to show the top 5. Automatically, the grand total will change to show sum of the top 5, and the percentages of all data obviously will change with the "new grand total" (filtered).
I want to create a pie graph with the pivot table only with the top 5 percentages but the information is not correct...
I want to apply the filter without changing Grand Total.
This is possible?
Can you help me, please?
Thanks!

Nuno W

[Swindon Dominic]

Hi Nuno

One way round this avoids VBA and filtering. Order the Pivot table so it is in descending values i.e. the biggest number is at the top. Have another sheet or area where there are five rows with formulas in two columns pointing to the labels and values in the label and values in the top five rows of the pivot table. You can get the total from the pivot table with a formula that gets the maximum in the pivot table value column.

Regards

Dominic

[Nuno W]

Dominic,

Thanks a lot for help me !
I will try your sugestion.
Regards,
Nuno W.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[Nuno W]

arlu1201,

Sorry for the inconvenience.
I didnīt know this procedure.
Thanks.