SOLVED

Filtros jerárquicos en una tabla dinámica

%3CLINGO-SUB%20id%3D%22lingo-sub-3209011%22%20slang%3D%22es-ES%22%3EHierarchical%20filters%20in%20a%20PivotTable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3209011%22%20slang%3D%22es-ES%22%3E%3CP%3EIs%20it%20possible%20that%20using%20a%20filter%20in%20a%20PivotTable%20binds%20the%20following%20filter%20in%20order%20so%20that%20the%20second%20filter%20only%20shows%20the%20fields%20that%20meet%20the%20requirement%20of%20the%20first%20filter%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3209011%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3213669%22%20slang%3D%22en-US%22%3ERe%3A%20Filtros%20jer%C3%A1rquicos%20en%20una%20tabla%20din%C3%A1mica%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3213669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1316675%22%20target%3D%22_blank%22%3E%40Fuensus%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20Hide%20items%20with%20no%20data%20in%20second%20slicer%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20416px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351246i108A6444C78A994C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

¿Es posible que al usar un filtro en una tabla dinámica se enlace al siguiente filtro en orden la selección realizada para que el segundo filtro sólo muestra ya los campos que cumplen el requisito del primer filtro?

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Fuensus 

You may Hide items with no data in second slicer

image.png

@Sergei Baklan 

 

Thanks a lot for your answer. It has been very useful. I did not know anything about slicers. I was hoping to have like and slicer within the dinamic table filters but I can get what I need through the slicers.

@Fuensus , glad to help