Grouping dates by Month and Week

[RWard003]

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]

@RWard003 

See Pivot Table Grouping Affects Another Pivot Table for a way to change that.

[#3]

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 :

Hope it will help.

Thanks

Tauqeer