Bar chart with multi dimensions

[RimDataAnalyst]

Hello everyone !

I want to visualize a bar chart for different aircraft configurations and calculate the potential value for them  : [AC Type] &'|'& [AC Subtype] &'|'& [AC Engine Type] &'|'& Conf  : i have a case wher i should choose two conf like this : 'A320|CEO|DAR|V2500|ACMS|DAR' so i think to add conf two times : [AC Type] &'|'& [AC Subtype] &'|'& [AC Engine Type] &'|'& Conf&'|'& Conf but it doesn't work 

this is the formula : 

=if (match( [AC Type] &'|'& [AC Subtype] &'|'& [AC Engine Type] &'|'& Conf&'|'& Conf ,' A320|CEO|CFM56|ADC|','A320|CEO|CFM56|ACMS|DAR','A320|NEO|LEAP-1A|ADC|','A320|NEO|LEAP-1A|ACMS|DAR',
'A320|CEO|V2500|ADC|','A320|CEO|DAR|V2500|ACMS|DAR'),
[AC Type] &'|'& [AC Subtype] &'|'& Conf &'|'& [AC Engine Type] &'|'& Conf )

i hope it was clear for you 

thank you 

[justISO]

Hi, it quite hard to understand the problem, but, if you have multiple Conf values, maybe it is possible to concatenate them, like:

concat(Conf, '|')