12 Replies Latest reply on Dec 12, 2019 4:55 PM by Andrew Esham

    Subtotal of Ranked data producing grand total value

    Andrew Esham



      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.