I have a matrix table in Report Builder where one of the columns is calculated by an expression, namely sum(units) / sum(deliveries). I want to filter the table so that it shows only certain rows, i.e. where sum(units) / sum(deliveries) >= 30.
However, I get an error when trying to filter the matrix table directly by the above expression: A FilterExpression for the tablix 'Tablix1' includes an aggregate function. Aggregate functions cannot be used in dataset filters or data region filters.
I wondered if there's any way around this other than writing the expression into my SQL query, as this is a rather complicated query and would take too long to explain.
I have tried writing what I would like to do into my SQL query but wasn't able to achieve this. Ideally, I need a way to do this directly in the report builder. Thanks :)