I have products whose price changes monthly (and whose volume as a % of total sales changes monthly). How can I create a quick and easy mix analysis? For example, in one month the price of all my products went up, BUT the average price went down because more of a cheaper item were sold. How can I demonstrate this with visualizations?
Please attach sample data as twbx format.