Hi All

I was wondering whether I can use VBA to be able to select a Field List in a row label in my power Pivot table. I have a Power Pivot table which has Division, Department and Score. I have designed a dashboard and what I need is if someone wants to view the whole store results then the Power Pivot with deselect the department Row Label and select Division as row label, but if someone selects a department then the power Pivot will deselect the Division and add Department in the row label.

Is this possible?

Hoe this makes sense