Hi All,
I got a request to create a dimension in below format. I know about the Tree view in List box but that is not what I am looking for. I want to use the output dimension as a Dimension in a Straight table with similar view.
Input Data: (Region - EU, Territory - Benelux/Central Europe, Country - Belgium/Netherlands/Germany etc)
Region-Territory-Country
EU |
EU-Benelux |
EU-Benelux-Belgium |
EU-Benelux-Netherlands |
EU-Central Europe |
EU-Central Europe-Germany |
EU-Central Europe-Poland |
Output required:
Region-Territory-Country
EU |
Benelux |
Belgium |
Netherlands |
Central Europe |
Germany |
Poland |
Thanks
Karthik