PDA

View Full Version : [SOLVED] Pivot Table grouping



austenr
09-20-2017, 03:30 PM
I need to group the following by weeks if possible:

January 1, 2017
January 2, 2017
January 3, 2017
January 4, 2017
January 5, 2017
January 6, 2017
January 7, 2017
etc.

In weeks hopefully to read in a slicer week of 1-1-17 to 1-7-17, etc. How can you group these and get something like that in a slicer option? Also I would like to add functionality to have a trend line by week of the data.

I can figure out the trend line but the grouping data by week has me stuck.

Paul_Hossler
09-20-2017, 04:54 PM
Can you add a helper column?

This used the built in WeekNum(), but you could make a more elaborate one that takes a date and returns a Begin-End: "9/10/17 - 9/16/17"

20416

Aflatoon
09-21-2017, 12:18 AM
You can group the date field by 7 day intervals, which should do what you want.

Paul_Hossler
09-21-2017, 06:03 AM
You can group the date field by 7 day intervals, which should do what you want.

Much better answer than mine

I forgot about that; I'm not sure when that feature was added, or if it's always been there, but is exactly what the OP wanted (probably)

20419

austenr
09-21-2017, 02:40 PM
Thanks you both. Solved.