Create a Dimension with Indents

[Anonymous]

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