Home

INDEX - Show Values as

%3CLINGO-SUB%20id%3D%22lingo-sub-654581%22%20slang%3D%22en-US%22%3EINDEX%20-%20Show%20Values%20as%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-654581%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20for%20the%20calculated%20measure%20Show%20as%20Index%20to%20be%20calculated%20from%20the%20subtotal%2C%20not%20grand%20total%3F%20We%20have%20table%20contains%20questions%20and%20we%20need%20to%20evalute%20them%20together%20in%20one%20pivot%20table%2C%20see%20print%20screen%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help%20on%20this%20task!!%20Lucie%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-654581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
lucie_rabochova
Occasional Visitor

Hello,

 

Is it possible to for the calculated measure Show as Index to be calculated from the subtotal, not grand total? We have table contains questions and we need to evalute them together in one pivot table, see print screen attached.

 

Thank you in advance for your help on this task!! Lucie

 

 

Related Conversations