Multiple dimension in single column

[bharathkamath28]

Hii, 

Anyone help me with this:

I have a input Region & City.

and output should be as below in pivot table:

[jonathandienst]

Why do you need them in one column? If its just for appearance, you could use indent mode (Styles tab)  in the pivot and remove vertical lines between cells. Set up any partial totals before switching to indent mode.

[bharathkamath28]

Thanks for the suggestion.

So, this is the input:

and the output should be:

[Shubham_Deshmukh]

Is there any special requirement due to which you are not using PIVOT Table?

[bharathkamath28]

I am not able to build this pivot table. I want to add Region and city in single column.

Pleas someone help me on this

[anushree1]

Following the comments Jonty gave i tried to set something with the Data given, Please check if the attached works

[Shubham_Deshmukh]

Anushree,
Can you put snapshot of these adjustments? I cannot open qvw.