How to filter on an aggregate measure but before aggergation is applied?
Hi,
When I include a measure in filter section (for eg: sale_amount > 10000 ), while having marked the measure with default aggregation as SUM in the BMM layer of RPD, I see the filter gets applies on the aggregated value. ie, the filter is applied after aggregating the sale_amount. But the requirement is to filter and identify the rows with sale_amount > 10000 and then aggregate. To accomplish this, I do not want to expose sale_amount two times in the presentation layer (once with aggregation enabled in BMM and another without aggregation), as this will confuse my power user community.
How can this be done?
Thanks,
SD