Home

Pivot table filters

%3CLINGO-SUB%20id%3D%22lingo-sub-660850%22%20slang%3D%22en-US%22%3EPivot%20table%20filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660850%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pivot%20table%20and%20I%20put%20%3CSTRONG%3E3%20manual%20filters%3C%2FSTRONG%3E%20(not%20slicers)%20in%20it.%20What%20I%20want%20is%20that%20when%20I%20use%20a%20filter%2C%20others%20modify%20their%20itens.%20For%20example%2C%20if%20I%20choose%20%3CSTRONG%3EUSA%3C%2FSTRONG%3E%20in%20the%20%3CSTRONG%3ECountry%20filter%3C%2FSTRONG%3E%2C%20the%20%3CSTRONG%3EStates%20filter%3C%2FSTRONG%3E%20will%20show%20only%20%3CSTRONG%3EUSA%20states%3C%2FSTRONG%3E.%20That%20happens%20only%20when%20I%20use%20the%20slicers%20filters.%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-660850%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
atnunes
Occasional Visitor

I have a pivot table and I put 3 manual filters (not slicers) in it. What I want is that when I use a filter, others modify their itens. For example, if I choose USA in the Country filter, the States filter will show only USA states. That happens only when I use the slicers filters. Any suggestions?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies