Total for Aggr dimension

[#1]

Hi,

I have a problem with aggregation functions.Am using an aggr fn as a calculated dimension.And am calculating the no:of fruits and % of total of products in the expression.Then in order to get the grand total of the columns am checking the 'show partial sums' in presentation tab.But the problem is am not gettin the column wise total instead the grand total is calculated based on row wise.Is there any solution to this?

	Mango		apple		grapes		Banana		Custard
Share	No. of	% of Total	No. of	% of Total	No. of	% of Total	No. of	% of Total	No. of	% of Total
0-20%	32	4.20%	366	94.10%	426	72.30%	460	95.40%	426	72.30%
21-40%	111	14.60%	23	5.90%	140	23.80%	21	4.40%	140	23.80%
41-60%	239	31.50%			17	2.90%	1	0.20%	17	2.90%
61-80%	203	26.80%			4	0.70%			4	0.70%
81-100%	173	22.80%			2	0.30%			2	0.30%
Grand Total	758	100.00%	389	100.00%	589	100.00%	482	100.00%	589	100.00%

I have to get something like this but my grand total is coming as 100% for all the rows.Share is the aggr calculated dimension.Please reply as soon as possible.

[#2]

Hi,

please provide some sample data (*.qvw if possible).

Rainer

[#3]

Fruitshop	FruitName	Share		Date
shop1	apple	30		2/12/2009
shop1	grape	20		2/12/2009
shop1	pineapple	9		2/13/2009
shop1	banana	16		2/14/2009
shop1	apple	23		3/12/2009
shop1	grape	12		3/13/2009
shop1	pineapple	37		3/14/2009
shop1	banana	10		3/15/2009

I hav data for 4shops.we need to calculate average of each fruit of each shop of particular date range(wch will be captured dynamically by the user).If user selectes 2/12/09 to 3/12/09 date range,then the average will be lik this for shop1.

fruitname apple grape pine apple banana

share 26.5 16 23 13

so i hav to get the table as

	Fruitshop	shop1		shop2
Share		No.of fruit types	%total	No.of fruit types	%total
0-20%		2	50%	null	null
20-40%		2	50%	null	null
40-60%		null	null	null	null
60-80%		null	null	null	null
80-100%		null	null	null	null
	Grand total	4	100%	null	null

plz suggest us ....

[#4]

Sorry,

no working idea yet.

Rainer