I am trying to create calculated measures which will show
amount X for items where amount Y falls within specified
bands, e.g. under 10,000, 10,000 - 20,000, etc.
I am trying MDX as follows:
Not IsEmpty(Sum(Filter({[Policy].[NewCOB].[Polid].Members},
([Measures].[Our Share Limit Conv]) < 10000), [Measures].
[Our Share EPI CONV]))

where the PolId level is the level I want to display
figures at, the Our Share Limit Conv controls the bands,
and the measure I want to actually see is Our Share EPI
Conv, but when I try to use this in ProClarity the query
never comes back. Could anyone help me with what I have
done wrong, please?
Thank you

Would anyone reading this please ignore my original
question as I have now resolved it
(FYI the correct MDX is
Sum(Filter(Descendants([Policy].[NewCOB].CurrentMember,
[PolId]),[Measures].[Our Share Limit Conv] < 500000),
[Measures].[Our Share EPI CONV])

)
However, I need to be able to have bands based on this
limit on the rows of the grid and bands based on a
different amount on the columns - but as these will all be
Measures I can't see how to do this, if it is possible at
all. Any ideas gratefully received!
Thanks
Rachel