4 Replies Latest reply on May 17, 2018 7:06 AM by waqar ahmad

    How do I sort on a calculated measure that has been converted to discrete?

    waqar ahmad

      Hi everyone, I have a calculated field that takes the MAX(Budget) field. I didn't want to see MAX(Budget) in the field header so I created a calculated field called "Budget-OA" which is what I want to see. Within this field is the MAX(Budget) function that gives me the proper results. I got the results I wanted but when I dragged the new calculated field to the rows, and made it discrete, I don't see the option to sort my data by my dollar values . Ideally id' like to sort by Budget-OA desc.

       

      Thank you for you help!

      wsorting.PNG