Hi,
I have a table which as STORES and REVENUE (measure that is computed in the report). Now, I need to filter the records based on this computed revenue. That is, I just need those records where the revenue > $2000. NOTE: If the measure was available as part of the Fact, then I could have just used a simple filter. But, like I said, the revenue is computed as part of the report..and the records need to be filtered based on this revenue.
I have a table which as STORES and REVENUE (measure that is computed in the report). Now, I need to filter the records based on this computed revenue. That is, I just need those records where the revenue > $2000. NOTE: If the measure was available as part of the Fact, then I could have just used a simple filter. But, like I said, the revenue is computed as part of the report..and the records need to be filtered based on this revenue.