I have a very complicated task that I can’t quite understand how to resolve.
I have data such as :
I want to have a chart showing the number of vehicles with one or more faults. I want percentages and actual figures.
However, I also need to use a filter - so I can see how many vehicles there are that have engine faults. I can’t use a traditional filter because I wouldn’t be able to get the total amount of vehicles. It shows me as having 3 engine faults out of 3 vehicles.
My dataset is much more complicated than this, however, this is the crux of the issue I’m having. Can anybody advise?