two fields in one dimension

[#1]

Hello!

i would appreciate your help in this matter.

Like in the picture i can have two fields in one dimension in a pivot table. how can i do this?

[Gysbert_Wassenaar]

You can't. The best you can do is add both dimensions to the pivot table and enable the Indent option on the Style tab. Then on the Presentation tab choose Subtotals on Top and left align the dimension cell values.

[lvf]

In the Dimension tab of your Pivot Table, use a Calculated Dimension and concatenate two dimension values together

e.g.

You could also do this in the Load Script if you want you use more than once.

[#4]

thank you Leona,

but then i will have something like this in the dimension.And the table would not have the same apperance.thank you anyway

[#5]

Hy Gysbert ,

I think this turn arround works for me.

thank you!