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.
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.