Is it possible to use a Pivot Table to display text instead of numbers? I have data that is text but when I put that in the values section (where it belongs) the pivot table won't display it as is. Just count of, sum of, etc
Thanks
Is it possible to use a Pivot Table to display text instead of numbers? I have data that is text but when I put that in the values section (where it belongs) the pivot table won't display it as is. Just count of, sum of, etc
Thanks
Last edited by SEMMatt; 11-16-2011 at 10:17 PM.
No, pivot tables are for aggregating number data. There are probably better ways of doing what you want if you can give more detail.
Remember what the dormouse said
Feed your head
I use Min or Max if the value is the same for the entire group. It looks a little odd, but it works.
***edit***
I must've been thinking of something else. I just tested my own suggestion and failed.
Sorry.
Last edited by Whizbang; 11-16-2011 at 02:19 PM.
ok thanks romperstomper. I'll continue using the sort and filter features.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks