Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Any pointers is appreciated.
Found a solution
sum( aggr( rangesum( above( sum(Value),0,NoOfRows()) ),Properties,Date))
Thanks