2 Replies Latest reply on Jun 9, 2016 9:42 AM by Kartikeya Khanna

    Can we stack (recursive addition) Sales/Any quantity for different groups over a time period?

    Kartikeya Khanna

      Good day everyone!

       

      Below is a demo of what I intend to build as part of my summer project. Consider we have 5 Sales Teams, A through E; 5 years under observation, 2001 - 2005; respective Sales volume for each of these teams for all these years. When I run the time-series (not sure what it is actually referred to as) under the highlighted portion below, for every year (2001-05) it displays the sales volume for each team, in turns.

       

      I require that instead of displaying volumes for teams over years, it should keep on stacking volumes for each team year-by-year.

      Consider for example Team A has Sales Volumes 5, 10, 15, 20, 25 over the 5 years, it should display the following results -

      2001 - 5

      2002 - 5 + 10

      2003 - 5 + 10 + 15

      2004 - 5 + 10 + 15 + 20

      2005 - 5 + 10 + 15 + 20 + 25

      instead of 5 -> 10 -> 15 -> 20 -> 25. And similarly for other teams as well.

       

      Show history does help to an extent but I would prefer using the stacking option. Any suggestions would be appreciated here!

       

      Attached the demo data.