Error al mostrar detalle en tabla dinámica (salen todos los datos)

%3CLINGO-SUB%20id%3D%22lingo-sub-1734101%22%20slang%3D%22es-ES%22%3EError%20displaying%20pivot%20table%20detail%20(all%20data%20output)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734101%22%20slang%3D%22es-ES%22%3E%3CP%3EDisplaying%20detail%20in%20a%20pivot%20table%20by%20double-clicking%20outputs%20all%20the%20data%20and%20not%20just%20the%20corresponding%20ones.%20How%20can%20we%20solve%20this%20pro%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1734101%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734154%22%20slang%3D%22en-US%22%3ERE%3A%20Error%20al%20mostrar%20detalle%20en%20tabla%20din%C3%A1mica%20(salen%20todos%20los%20datos)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734154%22%20slang%3D%22en-US%22%3EIf%20your%20question%20is%2C%20%22How%20can%20I%20display%20all%20data%20and%20not%20just%20the%20data%20corresponding%20to%20the%20value%20I%20clicked%22%2C%20the%20answer%20is%20double%20click%20the%20grand%20total.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734174%22%20slang%3D%22es-ES%22%3ERE%3A%20Error%20displaying%20pivot%20table%20detail%20(all%20data%20output)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734174%22%20slang%3D%22es-ES%22%3E%3CP%3EHi%20Craig%2C%20The%20problem%20is%20that%20when%20i%20make%20double%20click%20I%20obtain%20the%20whole%20data%20of%20the%20table%20(not%20only%20the%20correct%20items%20filtered).%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F234290%22%20target%3D%22_blank%22%3E%40Craig%20Hatmaker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Al mostrar detalle en una tabla dinámica haciendo doble click salen todos los datos y no únicamente los que corresponderían. ¿Cómo podemos solucionar este pro

3 Replies
Highlighted
If your question is, "How can I display all data and not just the data corresponding to the value I clicked", the answer is double click the grand total.
Highlighted

Hi Craig, The problem is that when i make double click I obtain the whole data of the table (not only the correct items filtered). @Craig Hatmaker 

Highlighted

Hi @jfrancia 

 

Please send copy of workbook. Let me see what is happening. Thanks