I have a table with orders and I used a pivot table to analyze/sort the orders by shop.
The chart displays only the total number of orders by shop.
Is it possible to display the total number of orders by shop as well as the the total number of orders for all shops like this:
The workbook can be downloaded from my dropbox: https://www.dropbox.com/s/yzbczwvqi8rqqt2/Orders.xlsm
Thanks for your help