I am trying to have text ("Y" and "N" and "X") show in my Pivot Table. Is there a way to display the text instead of the number one?
I am trying to have text ("Y" and "N" and "X") show in my Pivot Table. Is there a way to display the text instead of the number one?
You must convert the Y/N/X into numerical values then format the pivot table to display it as the desired TEXT result in the VALUES.
http://chandoo.org/wp/2012/05/07/dis...s-without-vba/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks