Filter Condition on Aggregate in a Crosstab/Dimensions not available?

nikhnath

Hello,

Trying to create a row-wise aggregate on a cross-tab. That is simple enough.

Where it gets tricky is when you try to use the "Filter Condition". I would like to Aggregate only when my Dimensions meet a specific criteria. The Aggregation Builder decides that it will let me Filter only on measures. The Dimensions are not available for selection in the expression builder.

So basically, I do not see a way to create a conditional aggregate on a cross tab that is based on an evaluation of the Dimensions.

Anyone run into this? Any workarounds ?

Thanks......