How to Custom Aggregates for Group level of Crosstab

[asini]

hello all,

i am having a small report (with crosstab in it)


Column Year
Rows Currency,Country,productgroups (here i am grouping by these columns for sub totals)
then factcells are a calculated weigted average ---> total (sales * noOfItems) / total(noOfItems)

so till here i am good to go

so now the requirement is i need to calculate weighted average subtotals for each productgroups, country, currency

so i tried to selecting fact cells and then goto aggregate (on tool bar) then custom it says "Custom Aggregates only for lists"

so what can do here, how can i get weighted average for summary (group by levels)

please help me sir
Thanks in advance
Sita

 

[asini]

Could anybody please share any ideas

please please

Thanks in advance
asita

 

[asini]

Could anyone please.....

 

[asini]

Please Kindly any ideas is it possible at all????

 

[asini]

Any one please

you can take own example just i want to get weighted average group level in crosstab


please..................
asini

 

[Danielbryanuk]

I think you need to chang the aggregatge function on your calculation to 'calculated', and also for the roll up calculation. Then in the report add the subtotals and they should automatically calculate for each subtotal level.

I've had a few issues in this area too, so I'd be grateful to know how you get on!

Dan