Aggregation for pivot

[#1]

Hello All,

Aggregation function not working properly.

At present i am getting values as

Type Of Plant	=DATE(Date)
A	4/1/2012	135.00
	5/1/2012	162.00
	6/1/2012	189.00
	7/1/2012	216.00
B	4/1/2012
	5/1/2012
	6/1/2012
	7/1/2012
C	4/1/2012
	5/1/2012
	6/1/2012
	7/1/2012

i need  is

Type Of Plant	=DATE(Date)
A	4/1/2012	135.00
	5/1/2012	162.00
	6/1/2012	189.00
	7/1/2012	216.00
B	4/1/2012	135.00
	5/1/2012	162.00
	6/1/2012	189.00
	7/1/2012	216.00
C	4/1/2012	135.00
	5/1/2012	162.00
	6/1/2012	189.00
	7/1/2012	216.00

ie In  the last field i should get the total for all the Type of plant wrt to a particular date

Please find the attached qvw.

Thanks and Regards,

Priya

[tresesco · Accepted solution]

Try this expression:

aggr(NODISTINCT(sum(HSD)-sum(Rated)),Date)

[#3]

Thanks a lot