DISTINCT COUNT in TOTALS and SUBTOTALS
Hi we have a report counting coustomer per product group:
product _group distinct_customer_count
Now I want a total in the report, that does the distinct count over both categories, let's say the 100 customers in the textiles all also bought from the hardware product group, therefore the total needs to be 150.
If I add a normal total in the report it will return 250, but not the 150.
Do you guys have any workaround or solution for this kind of problem, since I don't think it can be achieved with "normal" means.
Many thanks and best regards,