Good day all,
I am trying to do something which it my head feels quite simple but I can't get a result.
I have four dimensions in a spreadsheet report, lets say: make; model; fuel; engine.
Separately i have a list of exclusions which is a series of the four dimensions that I want to strip out of the report when analysing the report.
My exclusions list is also four dimensions but I want to be able to use wildcards to exclude certain combinations of the report.
The plan is to have a match function in the original report and use a flag to highlight those rows which match the criteria on the exclusions list. In the example below, on the exclusions list I want to exclude any row which has six as the engine, therefore I have used wildcards on the exclusions list for all other dimensions. This doesn't seem to work though.
Any ideas?
For example:
I am trying to do something which it my head feels quite simple but I can't get a result.
I have four dimensions in a spreadsheet report, lets say: make; model; fuel; engine.
Separately i have a list of exclusions which is a series of the four dimensions that I want to strip out of the report when analysing the report.
My exclusions list is also four dimensions but I want to be able to use wildcards to exclude certain combinations of the report.
The plan is to have a match function in the original report and use a flag to highlight those rows which match the criteria on the exclusions list. In the example below, on the exclusions list I want to exclude any row which has six as the engine, therefore I have used wildcards on the exclusions list for all other dimensions. This doesn't seem to work though.
Any ideas?
For example:
Report | Exclusion | ||||||||
Make | Model | Fuel | Engine | Exclude? | Make | Model | Fuel | Engine | |
Ford | Fiesta | Petrol | Four | * | * | * | Six | ||
Ford | Mondeo | Diesel | Four | ||||||
Toyota | Yaris | Petrol | Two | ||||||
Jaguar | F | Petrol | Six | X | |||||
Volkswagon | Polo | Diesel | Four |