Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nizamsha
Specialist II
Specialist II

Accumulation

Hi All

date and properties as dimension 

DatePropertiesValue
11/12/12A/c30
11/12/12Fridge20
12/12/12A/c40
12/12/12Fridge30
12/12/12TV60
13/12/12Fridge70
13/12/12LCD40



I have the following straight table what i want is  this

DatePropertiesValueresult
11/12/12A/c3030
11/12/12Fridge2020
12/12/12A/c4070
12/12/12Fridge3050
12/12/12TV6060
13/12/12Fridge70120
13/12/12LCD4040

in properties i have ac,fridge,tv and lcd .. in result i have some values ..how we r calculating the result is in properties field i have ac  for that i have result is 30. like wise i have fridge for that result is 20 but now is the point again in properties i have ac so .so already i hve value for ac is 30 but now i have 40 so it should sum 30+40 and display the result 70 like wise fridge too

0 Replies