0 Replies Latest reply: Jun 29, 2013 2:52 PM by Sudhakar Balakrishnan RSS

    Running Total based on second dimension

    Sudhakar Balakrishnan

      I have a straight table chart with Dimensions Date and Property and an expression with value like below:

      Date

      Properties

      Value

      11/12/2012

      A/c

      30

      11/12/2012

      Fridge

      20

      12/12/2012

      A/c

      40

      12/12/2012

      Fridge

      30

      12/12/2012

      TV

      60

      13/12/2012

      Fridge

      70

      13/12/2012

      LCD

      40

       

      I need the another expression added to this chart like the following

      Date

      Properties

      Value

      Total

      11/12/2012

      A/c

      30

      30

      11/12/2012

      Fridge

      20

      20

      12/12/2012

      A/c

      40

      70

      12/12/2012

      Fridge

      30

      50

      12/12/2012

      TV

      60

      60

      13/12/2012

      Fridge

      70

      120

      13/12/2012

      LCD

      40

      40

       

      Basically a running total on the second dimension value(A/c values get added, Fridge values get added etc.). The sort order has to be date first and then property.

       

      We are able to accomplish this if the sort is on property first with the above function. Also we could have two year data on the table with hundreds of properties. So need a flexible solution. Everything needs to happen in the chart not at the script level.

       

      Any pointers is appreciated.