Slicers, GETPIVOTDATA

%3CLINGO-SUB%20id%3D%22lingo-sub-1650925%22%20slang%3D%22en-US%22%3ESlicers%2C%20GETPIVOTDATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650925%22%20slang%3D%22en-US%22%3EI%20connected%20with%20slicers%20two%20pivot%20tables%20with%20same%20data%20source%2C%20I%20am%20getting%20data%20from%20those%20two%20pivot%20tables%20to%20my%20master%20table.%3CBR%20%2F%3ENow%2C%20please%20help%20me%20how%20can%20I%20exclude%20one%20slicer%20in%20another%20pivot%20table%3F%20For%20example%2C%20one%20pivot%20table%20is%20automatically%20giving%20me%20result%20on%20type%20and%20number%20of%20business%20unit%20and%20that%E2%80%99s%20fine%2C%20but%20in%20other%20pivot%20table%20I%20want%20my%20table%20to%20show%20only%20sum%20of%20all%20types%20of%20business%20units%20and%20not%20data%20for%20that%20specific%20business%20unit%2C%20for%20example%20if%20in%20slicer%20I%20select%20business%20unit%20number%202345%20the%20other%20pivot%20table%20should%20recognize%20type%20of%20that%20b.u.%20and%20do%20not%20shot%20data%20for%20b.u.%202345%20but%20far%20all%20types%20of%20business%20units%20that%20belong%20the%20same%20type%20group%20as%202345%20does.%20Please%20send%20some%20advice.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1650925%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
I connected with slicers two pivot tables with same data source, I am getting data from those two pivot tables to my master table.
Now, please help me how can I exclude one slicer in another pivot table? For example, one pivot table is automatically giving me result on type and number of business unit and that’s fine, but in other pivot table I want my table to show only sum of all types of business units and not data for that specific business unit, for example if in slicer I select business unit number 2345 the other pivot table should recognize type of that b.u. and do not shot data for b.u. 2345 but far all types of business units that belong the same type group as 2345 does. Please send some advice.
0 Replies