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
Bookmarks