1 Reply Latest reply on Mar 31, 2016 6:24 PM by swaroop.gantela

    Quick sorting Measure values and Dimension separately on a worksheet

    Abhishek yadav

      On worksheet I have 10 dimensions on row shelf  & 4 Measure values  on Measure Card . I am not able to perform Quick Sort using the Sorting Icon next to column names of Dimension & measure respectively

      but when I remove all the dimensions , measure values are getting sorted  but same does not go vice versa i.e  when I remove the measures, dimensions still are not getting quick sorted  . I need to have all the dimension & measure on worksheet and able to sort them individually . Please if someone can look into this issue. i am attaching the image for all the 3 scenarios.


      Thanks In Advance




      Img 1: Worksheet with both dimensions and measures


      Img 2: Worksheet with only  dimensions



      Img 3: Worksheet with measure value


      Note :Fields those are blank are hidden but not NULL