1 Reply Latest reply: Sep 5, 2018 3:20 AM by Arvind Patil RSS

    sort by expression in pivot with multiple dimensions

    Isabel Encinas

      I have 2 Dimensions :

       

      First Dimension, I used : aggr(Count([Score]),[Dimension1]) sort Descending and it is working fine.

       

      However, the Second Dimension: aggr(Count([Score]),[Dimension2]) sort Descending is not behaving like the first.


      I got this result:

       

      Dimension 1

      Dimension 2

       

                                          Count( Score)

      Program                            200                       

          Entrepreneur                  88

          Business                        90

          Shop                              70

      Business                          180

          Gas                                99 

          Garments                        90

            Metal                            98 

      ABC                                  150

          Special                            50

            Regular                        80


      Expected Result:

                                        Count( Score)

      Program                          200

           Business                      90

          Entrepreneur                88

          Shop                            70

      Business                        180

          Gas                              99

          Metal                            98

          Garments                    90

      ABC                                150

        Regular                         80

          Special                        50


      Please help with the correct expression. Thank you!