Information for Pivot Table


H

HL

I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks
 
Ad

Advertisements

T

Tom Hutchins

In an empty column adjoining your data, try:
=TEXT(F2,"mmm")
and copy down.

Hope this helps,

Hutch
 
D

Dave Peterson

As long as each entry in that field is a date (no empty cells and no text), then
you can create the pivottable and group the data by months (and years (I bet)).

Rightclick on the field (in the PT)
Select "Group and show detail",
Then Group.
 
Ad

Advertisements

R

Roger Govier

Hi

Within the PT, highlight any cell with a date>right click>Group &
Outline>Group>Months

--
-------
Regards
Roger Govier

HL said:
I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based
on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column
that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks

__________ Information from ESET Smart Security, version of virus
signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top