How can it works as a filter

[suvechha_b]

Hi All ,

Please see my attached sample model.

In the report , The status condition works base on calculation of the fields Stock on hand, Actual receipts, and Forecast units.

How to make the status filter work when selected ; "Stock out" or "No Stock Out".

[sunny_talwar · Accepted solution]

May be with a calculated dimension

=Aggr(If(GetSelectedCount(Status) = 0, [Product/Code],

  If(GetFieldSelections(Status) = 'Stock Out', if(sum(SOH)+sum(purchase_receipts)< (50/100 * sum([Forecast Units])), [Product/Code]),

  If(GetFieldSelections(Status) = 'No Stock Out', if(sum(SOH)+sum(purchase_receipts) >= (50/100 * sum([Forecast Units])), [Product/Code])))), [Product/Code])