How do I display text in the Data Area of a pivot table?
Y Yandi New member Joined Nov 24, 2014 Messages 1 Reaction score 0 Points 0 Nov 24, 2014 #1 How do I display text in the Data Area of a pivot table?
H Herbds7 Banned Joined May 8, 2013 Messages 197 Reaction score 0 Points 0 Dec 2, 2014 #2 PivotTable was never designed to display text in the Data Area. But with enough VBA trickery, anything can be created. Here is an example: http://www.mediafire.com/view/51r2xmhs0s7soc5/02_14_14.xlsm
PivotTable was never designed to display text in the Data Area. But with enough VBA trickery, anything can be created. Here is an example: http://www.mediafire.com/view/51r2xmhs0s7soc5/02_14_14.xlsm