Hello,
New question. I have this pivot table (see attachment). The procedure will be I will select values from the slicers then pivot table will be automatically updated.
Problem is, the % share at the last column is not always sorted (highest to lowest). I want it to be automatically sorted. I also want to show parts that are within 80% share. Example, 1st line is 60, 2nd line is 20, 3rd line is 10, etc. I only want to display the 1st and 2nd line because their total share is 80%.
Is there a way to automatically do this?
Thank you. More power!
Bookmarks