SOLVED

Valores en Gráficos y Tablas Dinámicas

%3CLINGO-SUB%20id%3D%22lingo-sub-2759661%22%20slang%3D%22es-ES%22%3EValues%20in%20Pivot%20Charts%20and%20Pivot%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759661%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%2C%20I%20would%20need%20to%20know%20if%20there%20is%20any%20way%20for%20only%20one%20value%20to%20appear%20in%20the%20PivotChart%2C%20for%20example%2C%20amount%2C%20and%20in%20the%20PivotTable%20the%20rest%20of%20the%20values%20are%20maintained%20(amount%2C%20percentages%2C%20differences%2C%20etc.)%20and%20porder%20drill%20down%20on%20the%20charts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3CP%3EA%20greeting%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2759661%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2760082%22%20slang%3D%22en-US%22%3ERe%3A%20Valores%20en%20Gr%C3%A1ficos%20y%20Tablas%20Din%C3%A1micas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2760082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1158831%22%20target%3D%22_blank%22%3E%40Carramos1980%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20you%20shall%20build%20PivorTable%20and%20PivotChart%20separately.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola, necesitaría saber si exite alguna forma de que aparezca en el gráfico dinámico solamente un valor, por ejemplo, importe, y en la tabla dinámica se mantengan el resto de valores (importe, porcentajes, diferencias,etc.) y porder hacer drill down en los gráficos.

 

Muchas gracias.

Un saludo

1 Reply
best response confirmed by Carramos1980 (Occasional Visitor)
Solution

@Carramos1980 

Nope, you shall build PivorTable and PivotChart separately.