Excel Pivot Table

[KMaples]

I am trying to display the date that employees took a training class in the data field of the pivot table. The table displays counts the date instead of displaying the date itself, no matter if I format each cell as a date. And This is the only section that I can place the date info for the report to make sense. Any thoughts as to how I might format the data section so it will display as a date?

 

[HaHoBe]

Hi, KMaples,

sorry, no - not precisely. Maybe you could attach a zipped workbook with a sample to have a look at?

Ciao,
Holger

 

[KMaples]

Pivot Table Problem

Holger,

Please find attached a copy of my pivot table example.

Thanks for your help,

KMaples

 

[HaHoBe]

Hi, KMaples,

when I glance through the options for the data range I do not find an option offering the date: only operations on the number of the data. The only other way of display I know is putting the dates in the column header for each course and finding the data that way - if you can live with less than 256 alternatives...

Ciao,
Holger

 

[shades]

Click on one of the cells in the Pivot Table, then right click and select "Field Settings". In the resulting dialog on the left, choose Sum instead of Count. Then click on the Number button on the right, and in the resulting dialog choose "Date" on the left side. Click OK. And Click OK. All the cells now display dates.
________
HERBAL VAPORIZERS

 

[HaHoBe]

Hi, shades,

good job, I didn´t know that. See how long that will stay in my memory...

Ciao,
Holger

 

[shades]

Thanks. It took me a while to learn all that - forced into it by a project about 8 months ago. Also, learned how to get numbers in one column and percent of those same numbers in the column next to it with weeks/months across as column headings. Relatively easy, but I never found a book that described the process, so it always seemed too hard. I even began writing VBA code to do Pivot Tables to get around that. Actually VBA for Pivots is much easier and you have much more control.
________
MXR-01

 

[KMaples]

Pivot Table Problem

Holger/Shades,

That was it exactly!!....I guess that I should have looked a little harder at this because, as per your instruction, it was so easy!..Thank you very much for your attention to this problem.

KMaples