Hope you can help
I have some data converted into a pivot table in Excel that contains some multiple criteria in terms of quantity, number of cartons per shipment and number of purchase orders that equates to these values.
At present, I set up a simple pivot chart for quantities and would like to insert a slicer that would allow me to choose between showing the quantity, number of cartons or number of purchase orders on the chart itself.
Ive tried altering the order of fields and even though the table contains the relative data, I cannot seem to get it to allow me to select the multiple options from one slicer - only separate ones.
If you could give me some ideas of how I can do this I would be very grateful – I have attached the sheet