Excel 365, Question Related to Excel table

(1) Share

Report

Posted on by CU02081924-0

I am working in excel 365, and I have in one workbook which contains YTD data of individual hierarchy and have all the YTD data with other KPI's, while in other excel table have the last 6 months data at individual level, both data have the unique employee id and are in the same format, filled, now I want to create the slicer from YTD data and want to create a slicer of region, market, and want when I used the region and filter any region, the same data should filtered in both excel data, could you please help me how this be possible in excel tables