3 Replies Latest reply: Aug 14, 2017 10:19 AM by Vishwarath Nagaraju RSS

    pivot table sort issues

    Alex Pan

      I have a pivot table with 5 dimensions and 4 expressions.

       

      one of the expressions are max(Days Open]). I want to sort by that only based on the last date (8/8/2017) but it does not seem to be working.

       

      I tried to use aggr(max([days open], max(loadDate)) in all the dimensions .


      Can you please help?

       

      thanks!