In this example I want to show the number of orders that have a category that contains more than 3 products.
What kind of calculation should I use for this?
Thanks
4 answers
Hi @Chris Calmeijer Meijburg
Try following:
COUNTD(if { FIXED [Order ID],[Category]:COUNTD([Product Name])}>=3 then [Order ID] end)