I have a pivot table for sales by car parts for the different manufacturers of cars.
In the filter there is a category for the manufacturer of a car(ie Honda, Ford, ect) and then I have the car part(ie suspension, brakes, engine, ect) also as a filter. I would like to be able to combine multiple car parts into one graph for just Honda by using the filters but haven't figured out a way to do so and I tried moving the car part filter under Legends and it didn't allow me to combine categories there either.
How could this be achieved?
thanks
In the filter there is a category for the manufacturer of a car(ie Honda, Ford, ect) and then I have the car part(ie suspension, brakes, engine, ect) also as a filter. I would like to be able to combine multiple car parts into one graph for just Honda by using the filters but haven't figured out a way to do so and I tried moving the car part filter under Legends and it didn't allow me to combine categories there either.
How could this be achieved?
thanks