12 Replies Latest reply on Aug 28, 2018 8:03 AM by Andrew Watson

    Aggregate and Non Aggregate issue in sort functionality

    shaheen.haque.1

      Hi,

       

      I have given user the functionality to sort by different measure by creating parameter, now it is working fine when i just using direct measure but when i am using any calculated field it is giving me error as "Cannot mix aggregate and non-aggregate comparisons or results in 'CASE' expression". Can someone help me here please.