I have the following MDX, but I can't figure out how to write this so
that I only get the aggregate of [Line Item Charge Amount] where
[Measures].[Line Item Payment Amount] = 0.

Select {([Revenue Center].[Revenue Center Code].Children)} On Rows,
{NonEmptyCrossJoin(
NonEmptyCrossJoin([Date - Transaction Date].[Year].Children,
[Date - Transaction Date].[Month].Children),
{[Measures].[Line Item Charge Amount]} )} On Columns
From [Main Cube];

how about create a calculate member as
with member [measures].[my Line Item Charge Amount] as
'iif([Measures].[Line Item Payment Amount]=0, [Measures].[Line Item Charge
Amount], NULL)'

then use the calcualte member in your MDX.

"passarellifamily (AT) yahoo (DOT) com" wrote: