Pivot Table and Dates (Excel 2013)

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

BratDawg

Carla
Thread Starter
Joined
Sep 23, 2004
Messages
677
Hi. I exported a list of invoices for the year. I was hoping to do a pivot so I could see how much I spend each month on a vendor - we get invoices every week.

I created a column and copied the invoice date and formatted it MMM - it shows Mar, Apr, etc.

I then did my pivot table and used that column as a chosen field. It is not rolling up the totals, though. It's showing them as if it was seeing the actual date behind, as if I never tried to format it by MMM.

What am I doing wrong?

Thanks
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
Hi Carla,
You have to keep in mind that a cell format does not change the way the data is in the cell, it's solely a visual modification.
Even if your data is formatted to MMM the cel contents will remain the same but will show up as Jun or whatever month the date is.
A Pivot table refreshes and the formats change at the same time.
I don't know it it works but if you have the filed selector in view you can select the individual fields when you're building the Pivot table and you can also set the desired format for each data type

Hope this helps, no guarantee that this is the solution though
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top