Hi,
I have a sheet with individual information for employee that I have created a pivot table from and added slicers, so far so good.
Now to the problem, one of the columns in the individual data sheet is BA (Business Area) and one is BU (Business unit / under BA). I would like to be able to send this out to each BA and lock the slicer to just show the BA in question and they can then filer/use slicer to see e.g. information about each of their BU's.
Is this possible? If I can't lock it, can I just sort it in some way so that they can't themselves add a slicer and see other BA's information?
I've tried to search a lot but can't seem to find a solution to this, or perhaps I'm just a rubbish searcher
/Per
I have a sheet with individual information for employee that I have created a pivot table from and added slicers, so far so good.
Now to the problem, one of the columns in the individual data sheet is BA (Business Area) and one is BU (Business unit / under BA). I would like to be able to send this out to each BA and lock the slicer to just show the BA in question and they can then filer/use slicer to see e.g. information about each of their BU's.
Is this possible? If I can't lock it, can I just sort it in some way so that they can't themselves add a slicer and see other BA's information?
I've tried to search a lot but can't seem to find a solution to this, or perhaps I'm just a rubbish searcher
/Per