7 Replies Latest reply: Mar 9, 2017 5:28 PM by Rob Wunderlich RSS

    Grouping Dimension & Expression in pivot

    m m

      I have following pivot table: (just for example)

       

      CountyCityPopulation (expression)
      USNY5
      Florida40
      Boston2
      LA1
      Phoenix2
      CanadaToronto35
      Kingston2
      Calgary1
      Vancouver2

       

       

      Dimensions = Country & City

      Expression = population.

       

      Now i want to group some City dimension together and similarly group their expression as well how do i accomplish that.

       

      Results:

      CountyCityPopulation (expression)
      USNY, Boston7
      LA, Phoenix3
      Florida50
      CanadaToronto, Kingston37
      Calgary1
      Vancouver2