4 Replies Latest reply: May 16, 2018 1:42 PM by chaitanya yelisetty RSS

    How to identify largest category and value?

    Virginia Slavin

      I have a list of products, A - X that are sold at various prices.  My table consists of records of each sale:

       

      Sales Table:

      Product          Location          Amount

      A                    OK                    4.56

      A                    LA                     12.45

      B                    KS                    5.00

      B                    MI                      3.75

      ... and so on.

       

      I have a pareto chart drawn, but I want a Text Box that says (for example):

       

      Top Product

      Product A, $25 total spend

       

      I am able to get Product A using:

      =FirstSortedValue([Product],-aggr(sum([Amount]),[Product]))

       

      But I don't know how to pull the summarized value for the top product.  In other words, I can generate the Top Product = Product A, but I can't generate the $25 Total Spend part of the summary.

       

      Any ideas?