Pivot Tables – Find difference between two columns set to '% of Column Total'?

I have a pivot table set up with two columns that are set to ‘% of Column Total’ under ‘Show Value As’ and would like to calculate their difference. I am using PowerPivot due to the large amount of rows.

  • How to put an ampersand in a header/footer in Excel?
  • Extracting multiple sheets and specific data from two sheets (“Input” and “AttributeInfo”)
  • Editing Hyperlinks Excel 2010 Macro
  • .VSTO access denied 0x80070005 error when installing from ClickOnce cache
  • Reading and writing access database table in python
  • Excel Median with nested if statement with wildcards
  • Pastespecial error on first run
  • Easiest way to count duplicate rows across multiple columns in Excel?
  • How can i extract data point value from tooltips of scatter plot?
  • Transpose data in Excel
  • Dynamic Milestone Trend Analysis Graph needs same y-axis as x-axis in Excel with VBA
  • VBA code not running with excel functions
  • One Solution collect form web for “Pivot Tables – Find difference between two columns set to '% of Column Total'?”

    what do you have on the ROWS fields on the pivot table , Dates ?

    MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.