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.