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

    Pivot table dimension

    Anagha Rao


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




      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?