8 Replies Latest reply: May 27, 2016 5:26 AM by kushal chawda RSS

    sorting if statement criteria within a pivot chart

    Laura Castagna



      the first dimension within my Pivot Chart dimension


      is Account,  the second reads like this:-

      =If(WildMatch(Code, '*WALL*'), 'Wall Paper',
        If(WildMatch(Code, '*PAINT*'), 'Paint',
        If(WildMatch(Code, '*NAT*'), 'Natural',' ' )))


      the Count "quantity"  is in the Dimension.

      so my chart looks like this:-

                          WallPaper        Paint               Natural

      Account A    10                    0                      6

      Account B      9                    5                      2



      I would like the sort order to be Natural, WallPaper, Paint.

      Where do i do this?

      I have tried an Aggr function in the  sort function with no luck.  Any help appreciated.