accumulation based on two dimension

[nizamsha]

Hi All

this is my inline table

	Date, Properties, Value
	11/12/12, Fridge, 20
	11/12/12, A/c, 30
	12/12/12, Fridge, 30
	12/12/12, A/c, 40
	12/12/12, TV, 60
	13/12/12, Fridge, 70
	13/12/12, LCD, 40

];

this is the output i want

	Date, Properties, Value result
	11/12/12, Fridge, 20,20
	11/12/12, A/c, 30,30
	12/12/12, Fridge, 30,50
	12/12/12, A/c, 40,70
	12/12/12, TV, 60,60
	13/12/12, Fridge, 70,120
	13/12/12, LCD, 40,40

];

i  have attached the qvw file here

[tresesco]

Can you please explain the logic of your 'Result' column ?

[nizamsha]

i have a properties field in that i have fridege,ac,tv,lcd

what the logic is  in properties i have fridge result is 20 and value also 20..like that i hve ac in properties for that i have result is 30 and value is 30 but in properties again fridge is coming.. but the result is how its coming mean fridge 20+fridge 30= result 50its should sum   like that for ac

for me result is coming correctly when i sort the properties ascending or descending but when i sort the date its not coming what i except

[nizamsha]

i am getting the result when i sort the properties ascending or descending but when i sort the date is not coming what i  except  when i sort date it should display the same like properties

[tresesco]

So basically you are looking to sort the table date wise, right? If so, go to sort tab and promote the Date to top.

Thanks.

[nizamsha]

i want to sort date wise and also with properties wise i promote the date to top but its not working

[nizamsha]

hi tresesco

i have attched a qvw kindly look at that

[tresesco]

If you want to sort on two dimensions, the first preference is given to the one at top and then to the one which follows.

[nizamsha]

Hi tresesco

its not working  i tried it result should be like this

40,70,70,100,120,40,60

even if sort each dimension one by one result should be like above

[tresesco]

Hi,

Sorry, I went through your attachment and first post, but completely lost, could not fugure out your actual desired output.