2 Replies Latest reply on Apr 6, 2017 12:01 PM by Jackie Morey

    How many customers sell Product B if they also sell A?

    Jackie Morey

      I want to figure out how many of my customers sell a specific product (call it product B) but only if they already sell another specific product (product A). I can get it to work but not in a set time frame, instead it looks at all of the data versus the time frame I have it filtered for.

       

      I am currently using suggestions from this blog post but it's not working properly since it's counting customers who have sold Product A ANYTIME instead of just YTD.

       

      http://ugamarkj.blogspot.com/2014/09/complex-level-of-detail-filters-data14.html