Group dates in pivot tables using different timelines
When you group dates in a pivot table in your workbook (e.g. months, quarters etc.), other pivot tables that point to the same data source are affected by the date grouping. This is because the pivot tables use the same cache in the workbook.
In this short video, I explain what a Pivot Table cache is and show you a simple trick to get around this challenge. #Microsoft #Excel