Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table data like the below,
Date Properties Value
01-01-2012 Fridge 20
05-05-2012 Fridge 30
01-01-2012 A/C 30
02-02-2012 A/C 40
02-02-2012 TV 60
07-07-2012 Fridge 70
08-09-2012 LCD 40
30-09-2012 LCD 40
I want the result in the below
Date Properties Value
01-01-2012 Fridge 20
05-05-2012 Fridge 50
01-01-2012 A/C 30
02-02-2012 A/C 70
02-02-2012 TV 60
07-07-2012 Fridge 120
08-09-2012 LCD 40
30-09-2012 LCD 80
How to get this result
Anyone having idea...above my question
Dimension : Date
Properties
Expression : sum( aggr( rangesum( above( sum(Value),0,NoOfRows()) ),Properties,Date))
Expression : aggr(RangeSum(Above(Sum(Value),0,NoOfRows())),Category,Date)