PivotTable report – Grouping the Date Field by Week Number in Excel 2010

In a pivot table, in order to group the dates, number and text fields or group dates by year and month. We can manually select the items in a pivot table field, and group the selected items. This will help us in findingthe subtotals for a specific set of items in the pivot table.

To create a pivot table report – grouping the date field by week, let us first create a pivot table report.
Let us take an example:

  • We have dates in column A from 1-Jan-2012 to 31-Mar-2013

img1

  • Click on Insert Ribbon to create a pivot table report
  • In Tables group, click on Pivot Table

img2

  • Create Pivot Table dialog box will appear

img3

  • Select existing worksheet option if we want to create the report in existing worksheet, otherwise click on OK to create the table in a new worksheet.

img4

  • Drag Date to Rows field & Sales to Values field.

img5

  • Now we need to click on any cell in column A (Date column) & right click and select Group option

img6

  • Select Days& enter 7 in number of days as shown below in snapshot

img7

  • Click on OK, and we will see the Sales will be segregated week wise.

img8

Grouping the dates will allow us to quickly find the sales in a particular period.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube