Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | canario71Starting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2004-10-13 : 10:04:42 
 |  
                                            | Hello everybody, this is the schema of my dimension: .+ country...+ region.......+ city..........+ office I have to modify the default aggregation because I need the average of the measures for each child of each level and not the sum. Please anyone can tell me how to modify the custom rollup formulas of each level? Tanks in advance. |  |  
                                |  |  |  |