Expanding a field when a slicer option is selected

Are you implying that the Pivot Table on which the Slicer is based has the column containing the names hidden?
Otherwise when you use the Slicer for the cost centres you'll see the names.

Hi Richard,

See attached pictures. I have the names collapsed, I would like to expand when the cost centre is selected on the slicer.

Picture 1 is the table with how I want it to look when all cost centres are showing.

Picture 2 is how I want it to look when I select a specific cost centre. But currently it only shows picture 3.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Not sure I still understand but maybe

Please Login or Register  to view this content.