Pivot Table Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-1283041%22%20slang%3D%22en-US%22%3EPivot%20Table%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283041%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20ahead%20of%20time.%20Can%20someone%20please%20help%20me%20with%20the%20steps%20needed%20to%20calculate%20the%20difference%20between%20two%20columns%20that%20I%20have%20showing%20as%20%22%25%20of%20parent%20row%20total%22%20in%20a%20pivot%20table.%20The%20insert%20calculated%20field%20function%20does%20not%20lend%20to%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1283041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1496618%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1496618%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610206%22%20target%3D%22_blank%22%3E%40ambernorris2000%3C%2FA%3E%26nbsp%3B%20I%20enjoy%20working%20with%20Pivot%20tables%20but%20I%20have%20also%20found%20a%20number%20of%20the%20Calculate%20As%20functions%20to%20be%20impossible%20to%20get%20working.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20trying%20to%20use%20the%20Difference%20From%20calculation%20but%20it%20is%20not%20clear%20what%20difference%20I%20would%20or%20should%20get%20if%20I%20select%20a%20Base%20Field%20and%20a%20Base%20Value.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20shed%20any%20light%20on%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Thank you ahead of time. Can someone please help me with the steps needed to calculate the difference between two columns that I have showing as "% of parent row total" in a pivot table. The insert calculated field function does not lend to this.

1 Reply
Highlighted

@ambernorris2000  I enjoy working with Pivot tables but I have also found a number of the Calculate As functions to be impossible to get working. 

 

I was trying to use the Difference From calculation but it is not clear what difference I would or should get if I select a Base Field and a Base Value. 

 

Can anyone shed any light on this?