Mutiple text values in a pivot table cell

[escobar1]

All,
I need to show clients in a pivot table according to two criteria.
Here is the raw data

[TABLE="width: 192"]
<TBODY>[TR]
[TD]Client</SPAN>[/TD]
[TD] type</SPAN>[/TD]
[TD] Region</SPAN>[/TD]
[/TR]
[TR]
[TD]client A</SPAN>[/TD]
[TD] Bank</SPAN>[/TD]
[TD] East</SPAN>[/TD]
[/TR]
[TR]
[TD]client B</SPAN>[/TD]
[TD] Fund</SPAN>[/TD]
[TD] East</SPAN>[/TD]
[/TR]
[TR]
[TD]client C</SPAN>[/TD]
[TD] Broker</SPAN>[/TD]
[TD] East</SPAN>[/TD]
[/TR]
[TR]
[TD]client D</SPAN>[/TD]
[TD] Bank</SPAN>[/TD]
[TD] East</SPAN>[/TD]
[/TR]
[TR]
[TD]client E</SPAN>[/TD]
[TD] Bank</SPAN>[/TD]
[TD]West</SPAN>[/TD]
[/TR]
[TR]
[TD]client F</SPAN>[/TD]
[TD] Fund</SPAN>[/TD]
[TD]West</SPAN>[/TD]
[/TR]
[TR]
[TD]client G</SPAN>[/TD]
[TD] Broker</SPAN>[/TD]
[TD]West</SPAN>[/TD]
[/TR]
[TR]
[TD]client H</SPAN>[/TD]
[TD] Bank</SPAN>[/TD]
[TD]West</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=3></COLGROUP>[/TABLE]


Here is the result I am looking for.

[TABLE="width: 144"]
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 128, bgcolor: transparent, colspan: 2"]Region[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Type[/TD]
[TD="class: xl65, bgcolor: transparent"]East[/TD]
[TD="class: xl65, bgcolor: transparent"]West[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Bank[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]client A
client D[/TD]
[TD="class: xl66, width: 64, bgcolor: transparent"]client E
client H[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Fund[/TD]
[TD="class: xl65, bgcolor: transparent"]client B[/TD]
[TD="class: xl65, bgcolor: transparent"]client F[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Broker[/TD]
[TD="class: xl65, bgcolor: transparent"]client C[/TD]
[TD="class: xl65, bgcolor: transparent"]client G[/TD]
[/TR]
</TBODY>[/TABLE]

Please show me how to do this in excel.

 

[circledchicken]

Hi and welcome to the forum,

I don't think there is a simple built-in way to have text in the values area of a PivotTable.
However, you can try a VBA alternative - here is a good example including a sample file:
Emulate Excel Pivot Tables with Texts in the Value Area using VBA - Clearly and Simply