I am trying to create a new dimension with certain criteria:
So the scenario is as follows:
I want to create a new dimension call cars, but for cars I have a multiple criteria to respond to. One i only want to show the car that is local and has a supplier of Ford and VW and that will be a Local Car, then I want to display the same criteria except the channel must be export and it will display as Export Car.
Then to add to this i want the same criteria but to exclude these selection for the supplier but only have the local and export as a factor to create a new Local Car field
if([supplier]='VW 'and [supplier]='Ford' AND channel='L',' Local Car', if([supplier]='VW' and [supplier]='Ford' AND channel=E,' Export SH', if([supplier]<>'VW' and [supplier]<>'Ford' AND channel='L',' Local Other Cars', if([supplier]<>'VW' and [supplier]<>'Ford' AND channel ='E',' Export Other cars')))) as Car,
