Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have tow tables.
Area | Mapping |
Canada | N |
China | N |
France | Y |
Germany | Y |
India | Y |
Italy | Y |
Japan | N |
UK | Y |
USA | N |
Country |
Australia |
Canada |
China |
France |
Germany |
India |
Italy |
Japan |
USA |
Expected output:
Country | Mapping |
Australia | |
Canada | N |
China | N |
France | Y |
Germany | Y |
India | Y |
Italy | Y |
Japan | N |
USA | N |
This can be achieved thru LOAD script without any issue.
But how to achieve through Expression in a Chart?
Thought this is a sample data, in my real scenario, I have few similar requirements.
Few expressions, which didn't work for me:
Only({<Mapping=p({<Country=p(Area)>})>} Mapping)
Only({<Country=p(Area)>} Mapping)
Only({<Area=p({<Country=p(Area)>})>}Mapping)
May be this -
Area as dimension and expression as -
Only({<Area={$(=chr(39)&concat(Country,chr(39)&','&chr(39))&chr(39))}>}Mapping)