date
in [General]
|
From: Rubem on 8 May 2010 12:07 Hi, I have a table if several columns. One of them is Invoice Date. I am using Pivot Table to compile the data. I am trying to find out how many invoices were issued in a particular month. First I convert the mm/dd/yy into mm/yy, but the Pivot Table gave me the result as mm/dd/yy. Then I copied the mm/yy and past special - value. Still I got mm/dd/yy on my Pivot Table. Any suggestion in how can I get how many invoices were issued in a particular month? Thank you. Rubem
From: Ms-Exl-Learner on 8 May 2010 12:54 Changing the Source Data Format wont reflect in Pivot Table Output, you should change the field format in the Pivot Table Layout itself. In your post you didn't mention which excel version you are using. Excel 2003:- In your pivot Table Layout Wizard>>Do Double Click on Date Field>>Select Number>>now you will get Format cells option and now select Custom and give your desired date format and give Ok. Excel 2007:- In your pivot Table Field List>> Click on Date Field>>Field Setting>>Number Format>>now you will get Format cells option and now select Custom and give your desired date format and give Ok. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Rubem" wrote: > Hi, > > I have a table if several columns. One of them is Invoice Date. I am using > Pivot Table to compile the data. I am trying to find out how many invoices > were issued in a particular month. First I convert the mm/dd/yy into mm/yy, > but the Pivot Table gave me the result as mm/dd/yy. Then I copied the mm/yy > and past special - value. Still I got mm/dd/yy on my Pivot Table. > > Any suggestion in how can I get how many invoices were issued in a > particular month? > > Thank you. > > Rubem
From: trip_to_tokyo on 8 May 2010 13:35 EXCEL 2007 "Any suggestion in how can I get how many invoices were issued in a particular month?" Take the following actions to achieve the above:- 1. Drag your date field (column) into the Values area of the PivotTable Field List (lower right hand corner). 2. Doing the above should then give you, in your Pivot Table, a Count of Date column and it is here that you will see the number of invoices issued in each month. If my comments have helped please hit Yes. Thanks. "Rubem" wrote: > Hi, > > I have a table if several columns. One of them is Invoice Date. I am using > Pivot Table to compile the data. I am trying to find out how many invoices > were issued in a particular month. First I convert the mm/dd/yy into mm/yy, > but the Pivot Table gave me the result as mm/dd/yy. Then I copied the mm/yy > and past special - value. Still I got mm/dd/yy on my Pivot Table. > > Any suggestion in how can I get how many invoices were issued in a > particular month? > > Thank you. > > Rubem
|
Pages: 1 Prev: compare 2 columns and select the lowest Next: FIND ERROR PROBLEM |