3 Replies Latest reply on Oct 10, 2018 4:33 PM by Tony Fahd

    How to be able to sort data based on If function?

    Tony Fahd

      I am attaching a workbook where I am trying to sort my categories based on an IF function. see below. I like to rank my categories based on average amount (IF function). I like to add other measures as well like amount, average spend...

       

      I created an index function that I can use to rank my categories. I can't seem to sort based on the average amount I created because it's an IF function. any help is appreciated.