I have an Excel 2010 pivot table based on 3 Power Pivot tables, which summarises goods moving on certain dates from one region/country into another region/country. An example would be 500 units in Jan 2015 moving from Europe/UK to Asia/Singapore.
For the pivot table I would like to have 2 separate groups of 2 linked slicers – one to select the Source Region and Source Country, and the other to select the Destination Region and Destination Country. When I select the 4 pivot fields to be slicers they all go inside one shape. If I cut and paste one the slicers it then shows as unchecked on the PowerPivot Field List. How can I get them into 2 separate slicer groups ?
A further issue is that the formatting of the slicers does not seem to permanent. For instance, I select one slicer to have 2 columns, I then click on the slicer and it goes back to having 1 column again. Any ideas on this ?
Thanks for your help
Bodders
For the pivot table I would like to have 2 separate groups of 2 linked slicers – one to select the Source Region and Source Country, and the other to select the Destination Region and Destination Country. When I select the 4 pivot fields to be slicers they all go inside one shape. If I cut and paste one the slicers it then shows as unchecked on the PowerPivot Field List. How can I get them into 2 separate slicer groups ?
A further issue is that the formatting of the slicers does not seem to permanent. For instance, I select one slicer to have 2 columns, I then click on the slicer and it goes back to having 1 column again. Any ideas on this ?
Thanks for your help
Bodders