Iām trying to filter out data from a dashboard.

I want to exclude transactions with a specific "**Division"** (Phocas **Property**) AND where the **Product Margin** (Phocas **Measure**) is less than 20% *(in the screenshot below that Measure is called:* **GM % COGS**)

*I also need to exclude some other Divisions carte blanche (as in: no matter the PM%, those Divisions should be excluded).*

These are the selections I have:

Where the 1st line has all the ācarte blancheā excluded Divisions as **Entity** exclusions.

And those lines below that in a **Calculation** is where the problem liesā¦

in the line for **a** - Itās taking all transactions of all Divisions where **Product Margin** is greater than 20%

and thenā¦ subtracting all transactions in the Liquidation Divisions (this āLiquidationā selection is the **(1)** shown in the line for **b**) where **Product Margin** is greater 20%

i.e. - itās showing this calculation only for transactions with a **Product Margin**% greater than 20 (aka - excluding all transactions in all Divisions with **Product Margin**% less than 20%)

**But I need the selections of those last lines to result in:**

All transactions of all Divisions (no considerations for **Product Margin**%)

and thenā¦ subtract any transactions in the Liquidation Division where **Product Margin** is less than 20%

I canāt seem to only apply that calculation filter of ā<20ā to just one measure though - itās applying it to both.

Any solutions would be appreciated.