Hi williams,
Could you share your expected result based on your requirement?
As per my understanding, if
----------------------------------------------------
Contoso(account) -> (associated opportunity)
3D Printer Purchase 1
3D Printer Purchase 2
Fabrikam(account) -> (associated opportunity)
6 orders of product SKU
----------------------------------------------------
So you would like to display 3 records in a report?
Or count different opportunities based on their Account field?
Then above data will be
Contoso 2
Fabrikam 1
It seems that rdl report is no longer available in Dynamics 365 for marketing,
but you can instead build a chart as alternative.
Regards,
Clofly