Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
please provide some sample data (*.qvw if possible).
Rainer
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 ....
Sorry,
no working idea yet.
Rainer