40 Replies Latest reply: Apr 7, 2015 4:24 AM by Lavanya Ramaswamy RSS

    How to create this pivot ?



      I am trying to create the following pivot


      Basically, there is a period selector which is used to Select Jan - 15, and the bands on the left (in red) are the aging bands.


      I want to represent that there are 73 people who were in the band 11 - 20 in jan-15 moved to 0 - 10 in Feb-15 and 82 in 0 - 10 in mar - 15


      I am trying to show if there is a pattern in movement between bands across periods

      pivot sample.png

      Is this even possible ?


      Please advise.