Is There a Way to Control the Field Used in a Row by a Slicer in a PivotTable

[CSMcVey]

I have a current PowerPivot file that had a hierarchy as follows:

• Division
• Region
• Sales Rep
• Headquarters
• Firm

I then have some metrics like:

• Open Orders
• Closed Orders
• Revenue
• Claims

I have a PivotTable and I would like to control what field is placed on the rows by the use of the filter. I currently have the entire hierarchy as the rows and they are nested. What I really want is if the user selects 'Division' from a 'Visibility Slicer' then the Division values would be seen in the rows. If the user selects 'Sales Rep' then the Sales Rep values would be seen in the rows. I would likely only want one value to be selected and can add some logic about what to do if they choose multiple.

What I don't know how to do (or even if it is possible) is - how to control what field is used in the rows by a slicer.

Thanks in advance.

 

[pete234]

Maybe some vba to adjust the pivot table for the row values attached to some buttons or option boxes and maybe one slicer for some category you wouldn't need to adjust like Region?
Changing row values is not a filter process so not sure how this could work on slicers. I found this maybe it could help with understanding how to start.

VBA to Change Row Filters for Multiple Pivot Tables off of a Predetermined Range