How to create an qty sold percentage saved search ...
# general
m
How to create an qty sold percentage saved search by item or category? Trying to create a sales order saved search and see by product or product category, what proportion of the period is by each product. i.e. date is Jan 24. 5 products, total is $150k. Product A is $10K, B is $20K, C is $30K, D is $40K, E is $50K.. how to get a percentage for this and then again if period changes then so should the results.. 1 thing I'm assuming we would have to do is group the sales order Products so will probably be a grouped saved search.. any ideas? Open to alternative solutions as well