Need help on pivot slicer for extract data from multiple sheet into main sheet

HI experts how r u all

i need a great help for my project which is make easy for view in single hand

i have set of data in 2 sheet i want list out data from both sheet Jan and Feb, into main sheet by click slicer of Region list, Branch list, at list out TID

for e.g if i click any region name on slide area under region all branch will display
if i click any branch name on slide area under branch all TID NO WILL DISPLAY
If i click any TID JD_CC_005 then all particular data will display on both range from sheet jan and feb
if i have not click any , all TID ALL data will be display under selected branch.

please find example_workbook the sample working job i want as same but from 2 sheet

Hi,

Please find attached sheet containing the solution to your requirement. Below are some of the items to keep in mind.

1. The tab SlicerTables contains the unique values of all the slicers, i.e., TID, Branch and Region
2. If you want to add more values, you can do so in the tab mentioned in point 1 and refresh all pivots
3. In the pivots, the TID column and the distinct count of TID should be present in order for the solution to work.

Thanks alot experts, i got one more question how to make changes of slicer color and styles, i couldnt find option slicer in tab list. i want look like E0 sheet design.

Hi,
Just select the slicer that you want edit and go to the Slicer task bar and check there are patterns that are available. I am able to change the slicer styles in the sheet I uploaded yesterday.

I have changed the slicer styles and attached just for your reference.