If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Information for Pivot Table
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 |
#2
|
|||
|
|||
Information for Pivot Table
In an empty column adjoining your data, try:
=TEXT(F2,"mmm") and copy down. Hope this helps, Hutch "HL" wrote: 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 |
#3
|
|||
|
|||
Information for Pivot Table
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. HL wrote: 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 -- Dave Peterson |
#4
|
|||
|
|||
Information for Pivot Table
Hi
Within the PT, highlight any cell with a dateright clickGroup & OutlineGroupMonths -- ------- Regards Roger Govier "HL" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|