Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Custom Aggregates for Group level of Crosstab

Status
Not open for further replies.

asini

Technical User
Nov 13, 2008
22
US
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
 
Could anybody please share any ideas

please please

Thanks in advance
asita
 
Please Kindly any ideas is it possible at all????
 
Any one please

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


please..................
asini
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top