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



      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.