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
