I have a pivot table that shows percent of total value per item. I need to be able to do 2 things:
- Only show top 5 items where item 5 is a sum of all lesser values
- Group values lesser than a specified tolerance
This has to be automatic because the pivot is connected to slicers which refresh based on filters.