Expand my Community achievements bar.

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