Terence Mervis
New Member
Hi,
[Excel 2010] I have several PT from the same source data. For each PT, the dates (in the Row segment) are grouped differently, for example - PT1 = by weeks, PT2 = by Months and Years etc. The only way to do this was to create a separate cache for each PT. However, in doing so, I can't connect these PT to one common slicer. This is a "catch 22" situation. Is there a way to get around it? Many thanks
[Excel 2010] I have several PT from the same source data. For each PT, the dates (in the Row segment) are grouped differently, for example - PT1 = by weeks, PT2 = by Months and Years etc. The only way to do this was to create a separate cache for each PT. However, in doing so, I can't connect these PT to one common slicer. This is a "catch 22" situation. Is there a way to get around it? Many thanks