6 Replies Latest reply: Dec 14, 2017 7:10 AM by Sunny Talwar RSS

    Pivot table dimension

    Anagha Rao

      Hi

      I am using the below expression in the pivot table for a dimension

       

      AGGR(MAX(PRIORITY),EMP_ID)

       

      this works well, and provides the below table

       

      Business Area      AGGR          Count

      BA1                         4                    4

      BA1                         3                    1

      BA2                         4                    3

      BA2                         3                    1


      Now, i would like to replace the appr value with an understandable text. (desc4 for priority 4... )

      Business Area      prioity desc         Count

      BA1                         desc4                         4

      BA1                         desc3                        1

      BA2                         desc4                         3

      BA2                         desc3                         1


      how would i be able to do that?