Workaround to evaluate condition at row level

Defo — Mon, 16 Oct 2023 14:55:31 GMT

Hi everyone,

I have to calculate in a table the total amount of purchases made by customers who have placed an order for at least 2 different types of product.

YearMonth	# Customers multi product type	Sum of purchases
2023-01	50	300€
2023-02	45	400€
2023-03	70	290€

I know that Set Analysis is evaluated only once when calculating the chart values and as a workaround for the number f customers I used:

Count( distinct {<[Flag Buyer] = {'1'}>}

IF(
aggr(count(distinct {<[Flag Buyer] = {'1'}>} [Product Type])
,[Customer ID],YearMonth)
>1
,[Customer ID])

)

I can't find a way to obtain the Sum of purchases of only these customers.

How can I obtain the result?

Thanks in advance for any advice 🙂

Davide

topic Workaround to evaluate condition at row level in App Development