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

    How to create this pivot ?

    Lavanya Ramaswamy

      Hello,

       

      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.

       

      Thanks