1 2 Previous Next 22 Replies Latest reply on Mar 21, 2017 11:57 AM by Leanne Vermeulen

    Show Count of Items Ordered for First Time Purchases Only

    Leanne Vermeulen

      Hey guys,

       

      I'm struggling to replicate the chart below, but to show the count of items ordered [Item] for first time purchases only, instead of the sum of sales per Item for first purchases only. So the LoD expression I created for First Purchases is being used in the filter and works fine when calculating the SUM of Item sales for those days (by [Cust ID] - aka Customer ID). But no matter what calculations I create, I cannot get accurate results for the amount of times an Item was purchased, for First Purchase only.

       

      Show Count of Items Ordered for First Time Purchases Only.png

       

      Any ideas? Thanks, guys!

        1 2 Previous Next