7 Replies Latest reply on May 7, 2018 1:09 PM by Jim Dehner

    Create a Pie Chart using based on a unique count of string values

    Logan Irmscher

      Hello,

       

      I have been trying to create a pie chart based on a unique count of our vendors, broken out into different categories. Each vendor can have multiple categories, however I only want each vendor counted once, and for it to be counted in the category it has the highest spend in.

       

      See data below:

       

      Based on the data above, I should get a pie with the following results:

                          Category          Unique Count

                          Goodbye               3

                          Hello                     1    

      For Logan, it selected "goodbye" because that is the category that it had the highest spend in.

       

      Is there a formula for this? Any help would be greatly appreciated.

       

      Thanks,

      Logan