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 |  
                                    | bereniceStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2004-12-01 : 08:10:28 
 |  
                                            | A store can be one of a number of ‘Brands’. The MDX segment below gives me the Sales Value of a selected item, but for Store Brand 'Brand1' only. This works fine - but how do I add a brand? That is, how do I see the combined Sales Value for the selected item for 'Brand1' and 'Brand2'? ([Store Brand].[Brand1],[Measures].[Sales Value],[Item].CurrentMember)B |  |  
                                |  |  |  |