Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Be able to do a count of the products variable in Discover

Avatar

Level 4

12/15/11

I simply want to see all order #s whereby the count of the products purchased is >1.  I can run my EVAR for the order # or the purchased id. I can then in Discover drill down on products purchased--but to roll up all the ones whereby 2+ products were purchased is difficult.  I'm resorting to using Datawarehouse to do this & then put the results into in MS Access so I can group by order # & count on products. 

1 Comment