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?!