Grouping dates by Month and Week

%3CLINGO-SUB%20id%3D%22lingo-sub-2214525%22%20slang%3D%22en-US%22%3EGrouping%20dates%20by%20Month%20and%20Week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2214525%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20use%20the%20same%20data%20set%20to%20create%20pivot%20tables%20to%20display%20data%20by%20month%20and%20then%20by%20week%20in%20a%20separate%20table%3F%20I%20am%20trying%20to%20do%20so%20on%20separate%20pages%20within%20the%20same%20workbook%2C%20but%20the%20changes%20to%20the%20grouping%20are%20affecting%20both%20pages.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2214525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

How can I use the same data set to create pivot tables to display data by month and then by week in a separate table? I am trying to do so on separate pages within the same workbook, but the changes to the grouping are affecting both pages. 

2 Replies

Hi @RWard003 

 

You may achieve your requirements by using separate Timeline Slicers for each table and then restrict slicer connection to relevant table only as mention below :

tauqeeracma_0-1615915897155.png

Hope it will help.

 

Thanks

Tauqeer