topic Re: single table and two column in App Development

single table and two column

HKN1 — Mon, 24 Feb 2025 15:29:50 GMT

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.

Re: single table and two column

JandreKillianRIC — Tue, 25 Feb 2025 10:58:40 GMT

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