Hello All,
Please find below the raw data and pivot table
My requirement is, If i select "India" in "ops_center" slicer, the chart has to show only the "Mgrs Name" for "India" center like below
The same way, if i select "Australia" in "ops_center slicer, the chart has to change like below
I need help either in terms VBA or excel pivot tables option.
Regards,
T
Please find below the raw data and pivot table
My requirement is, If i select "India" in "ops_center" slicer, the chart has to show only the "Mgrs Name" for "India" center like below
The same way, if i select "Australia" in "ops_center slicer, the chart has to change like below
I need help either in terms VBA or excel pivot tables option.
Regards,
T