Hi,
Does anyone have an idea how do I put the date and time in two different columns in the attached pivot table?
Thx in advance,
Hidai
Hi,
Does anyone have an idea how do I put the date and time in two different columns in the attached pivot table?
Thx in advance,
Hidai
Last edited by Hidai; 01-05-2011 at 02:15 PM.
Click in the Pivot table, then go to the Pivot Table Design Tab. Click Report Layout and select Show in Tabular Form
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
Given reply on this thread I will now close the other
Going forward do not post in duplicate.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Or right click on one of the dates within your pivot table and select "Field Settings" and then "Layout and Print" and unselect "layout and print next field in same column"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Ok. thx a lot for that. How do i get rid of the row that shows me the total in each and every date?
Right click on the date and uncheck "Subtotal Date" Does that do it?
Yes! Thx a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks