Hi All,
I have used multiple consolidation ranges from 4 tabs to 1 pivot table that have data pulling from 4 connections. From this Multiple consolidation ranges pivot table I am trying to group a date column however when I try to do this it will not give me the option to select Days, years, quarter, etc. It will just group everything into "Group 1".
I have seen online that this could be happening do to blank cells?
Any help/workarounds would be great.
Thanks in advance,
Bjorn
I have used multiple consolidation ranges from 4 tabs to 1 pivot table that have data pulling from 4 connections. From this Multiple consolidation ranges pivot table I am trying to group a date column however when I try to do this it will not give me the option to select Days, years, quarter, etc. It will just group everything into "Group 1".
I have seen online that this could be happening do to blank cells?
Any help/workarounds would be great.
Thanks in advance,
Bjorn