Pivot table text not values

[Dharris144]

Hello everyone,
I am using Excel with a table dump from ERP system.
In the example below I am trying to create PT that returns the text value instead of number or formula. In the column ADHOCV all the values under should be ADHOCV not 0. Is this possible? I can do find and replace but this is obvoiusly not the best solution.

Any help you can give would be deeply appreciated.

Sum of KUVTDT	Column Labels
Row Labels	ACCTBL	ADHOC	ADHOCV	ALL	ALLDISP	APAPR
AAHKUR			0
ABANIC			0	0
ABOLIN			0
ABRJUS
ABRSOR			0
ACKSTE						0

 

[alansidman]

This may be achievable with your data in Power Query. When you pivot your data, you need to select "Do not aggregate." I have never seen functionality available in a regular Excel Pivot Table.

 

[Dharris144]

This may be achievable with your data in Power Query. When you pivot your data, you need to select "Do not aggregate." I have never seen functionality available in a regular Excel Pivot Table.

I agree and will give Power pivot a go

 

[alansidman]

I'm not sure about Power Pivot. I mentioned Power Query. However

IMA Site Maintenance