Forum Discussion

Chris Sanders's avatar
Chris Sanders
Copper Contributor
May 24, 2018
Solved

Performing calculations on Pivot Table data

Hi,    I am using pivot tables to look at data from a large set and I want to sum the largest 5 values in a pivot table column and calculate it's % of the total of that column. If the range was sta...
  • JKPieterse's avatar
    May 29, 2018
    You could define a dynamic range over the pivottable and use the dynamic range as the argument for the LARGE function. Alternatively, why not define a second pivottable tied to the same slicer which shows top 5?

Resources