1 Reply Latest reply: Sep 13, 2014 7:02 AM by Marco Wedel RSS

    Weekly order comparisons

    Jason Westwood

      Hi All,

      wonder if you could help I am looking to produce a chart

       

      I want the chart to display customer name and show there weekly trading so there sales amount and there order amount. and see if there is a spike within the month where they are sending more orders for example week one is quiet but week 3 and 4 they are placing a unachievable amount of orders.

       

      but I only want this chart to display where a variable is set on there total sales revenue a month is above a set amount for example I can put in £50,000 and above and it will filter the chart with the required info

       

       

      what would be the best way to do this? I currently hold the week number in my data

       

      thanks in advance

       

      Jase