• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Excel PivotTable

Hi,

I have a large DB which I am using a PivotTable to get the information into a useable format however for some reason the usual Excel function whereby dates in a DB are grouped into Month and Year is not working and rather it is only grouping by individual days... file is attached and the date field is up the top part of the report filter

Thanks
Purchases.xlsx
0
recycleaus
Asked:
recycleaus
1 Solution
 
ltswebCommented:
Been there!  I use the =month function and create a new column that I use to sort by month and same for year.  

Here is a more clever way to do it.

http://www.exceltip.com/show_tip/Excel_Pivot_Tables/PivotTable_report_-_Grouping_the_Date_Field_by_Days,_Months,_Quarters,_and_Years/747.html

Good luck.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now