I have a pivot table populated from a source to which I have no access (the source is password protected, and someone else updates my pivot weekly). My problem is that one field I bring in has these as titles:The 01 through 12 denote expenses by month throughout the year. I'd like to have the pivot display these as month names. Given my limited access to the data, how could I go about doing that?
Please Login or Register to view this content.
Last edited by jomili; 10-06-2010 at 11:36 AM.
Can you not just edit the text in the row field of the pivot table?
Well, I'll be .... I never knew you could do that!
Boy, do I feel dumb!
Never mind. And thank you.
Hi,
How about a VLOOKUP() column of cells outside but adjacent to the 01, 02 etc, month number references. Create a two column table of month number ref and month name for use in the VLOOKUP()
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks