Aggregate Filter by Formula
I have an aggregated table that shows a selected company's prescriptions and compares them to the rest of the industry. The table groups by a drug category, then shows the selected company's data (# prescriptions, total cost, total sales, etc) and compares that to the rest of the industry.
When the selected company has 0 total prescriptions for a drug category, I want to suppress that row in the aggregate table. However, "Filter Aggregate Values" will not accept a "New Formula" and allow you to specify the filter formula. I can drag "Number of Prescriptions" into an aggregate filter and select only rows where SUM() > 0, but that applies to ALL the prescriptions in the row when I want to filter out rows where SUM() = 0 for the selected company only.
Is there a way to accomplish this? Why can't you use a formula on insight aggregate filters?