Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

MDX - Children Sum or Max Measure

Avatar of WaterAid
WaterAid asked on
DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2005
10 Comments1 Solution2219 ViewsLast Modified:
Hi there

I wonder if you can help...  I have a very simple report that details the performance of mailing and I'm having trouble displaying some of the data correctly.  The mailing is sent to a number of different segments and the performance of these segments is rolled up at group level.  The view this report is based on pulls together two tables, one which contains the topline details of the segment (volume per segment, cost etc) and the other, primary table,  for responses (Income, Date etc).

When trying to detail the Volume for each Segment, I've just used the MAX function - this works fine is you only view data at the Segment level.  However, when adding in the Segment Group parent dimension, the MAX function simply picks out the highest value from the children Segments (highlighted in red).

What MDX can I use to accurately capture this data?  ie To get that cumulative Volume to 6480?!
And is there a more truthful way of deriving that figure for the Segments too?!

With thanks Problem Measure
ASKER CERTIFIED SOLUTION
Avatar of Tim Humphries
Tim HumphriesFlag of United Kingdom of Great Britain and Northern Ireland imageDirector

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 10 Comments.
See Answers