single table and two column

[HKN1]

Hello,

I have a single table (data source). I want to list the statuses that are False in a separate column. However, I also want to include the non-matching ones. I need the output exactly as shown in the final table.

How can I achieve this?

Thank you.

[JandreKillianRIC]

Hi @HKN1 

Just add 3 columns, 1 is a Dimension, 2 and 3 are measures

1. Return Product: IF(Status = 'FALSE', Product) 

2. Return Product Quantity: Sum({<Status = {'FALSE'}>} Quantity) 

3. Total: Sum(Quantity) - Sum({<Status = {'FALSE'}>} Quantity)

Regards Jandre