4 Replies Latest reply on Nov 12, 2019 3:38 PM by Andrew Esham

    Subtotal of Ranked data producing grand total value

    Andrew Esham

      Hello,

       

      I am ranking the top 10 selling brands for 2018 vs. their sales in 2017.  I created a calculated field "Rank" and filtered if for 1 to 10.  I need to total just the top 10 brands.  If I apply Grand Total or even Subtotal, the value returned it the sum of all brands, not just the top 10 (sum = 1,068,254).  How do I limited the total to just the listed brands>

       

      Attached is the packaged workbook.

       

      Thank you for your help.

      Andrew