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개
Hi @Chris Calmeijer Meijburg
Try following:
COUNTD(if { FIXED [Order ID],[Category]:COUNTD([Product Name])}>=3 then [Order ID] end)