Hey there,
I have no experience with Pivot Tables and so I need your assistance regarding a very basic issue.
In the file attached you can see that similar dates in column A are grouped together in the Pivot Table. I just want pivot table to show all individual rows instead of grouping similar items together.
I really appreciate your assistance
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Hi Sourabh,
In your PT, right click in the Date field, go to Field Settings, on the Layout & Print tab check the Repeat Item Labels box. Hope that fixes you up.
Hi,
Thank you for your response.
I think that this option is unavailable in EXCEL 2007 which I am using.
Any thoughts?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks