9 Replies Latest reply: May 12, 2014 8:05 AM by Chinni Kanna RSS

    Creating a variable to count customers spending over a certain amount

      Last week I asked a question where I wanted to count customers spending more than £500 who were buying specific products. Someone gave me the answer to that particular question with this bit of code: count({<location_id={"=Sum(customer_gross_sales)>500"}>}location_id)

       

      I then want to be able to say what percentage of customers spending more than £500 are buying each product. My question is how to count all of the customers and not just those related to the particular product? Could I establish a variable to count them and then use this?