Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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