Hello All,
I have 2 pivot tables based on the same range of data. There are reasons why these need to be separate for my use so they can not be combined. I am now introducing slicers to my worksheet. However, is there a way to make the position of my pivot tables dynamic based on the slicers selected? Meaning, to remove the extra blank columns between the 2 pivot tables when limited slicer categories are selected and to move the 2nd pivot table over when more categories are selected?
I have 2 pivot tables based on the same range of data. There are reasons why these need to be separate for my use so they can not be combined. I am now introducing slicers to my worksheet. However, is there a way to make the position of my pivot tables dynamic based on the slicers selected? Meaning, to remove the extra blank columns between the 2 pivot tables when limited slicer categories are selected and to move the 2nd pivot table over when more categories are selected?
Last edited: