Hi all
I am having a terrible time working out how to show all dates in a pivot table rather than have them bunched together by month. Is there something I am doing wrong?
excel question.JPG
Seems odd to me, the screenshot above shows all the date field broken out, Can't get down to individual dates. Any help much appreciated.
Uncheck the boxes next to Quarters and Years in the top box of the dialog.
Bernie Deitrick
Excel MVP 2000-2010
Hi Bernie
I just unchecked those boxes and it actually leaves me with just the motnhs, how do I show the exact dates? I wanted each individual dates rather than grouped by month.
Try right-clicking the row area of your pivot table and choose "UnGroup"
IF that does not work, post a small sample of your data - but it should work.
Ahhhh thats done the trick, thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks