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