% difference from

  1. K

    How to calculate a difference between two value sums in a pivot table

    Hi all, I would really appreciate some help on this really manual piece of work and hope there's an easier way. Below is a dummy dataset from data.world that is similar to my real dataset. I am working on a pivot table and I have two values in the 'values' field - one is the sum of the total...
    • KayB14
    • Thread
    • % difference from pivot table value field settings
    • Replies: 1
    • Forum: Excel Questions
  2. T

    2nd request: How to change pivot table "% Difference From" to "LN Difference From" without VBA?

    in Excel 2010, how to (or is it possible?) to change the pivot table "% Difference From" to "LN Difference From" without VBA? That is embed LN( row b / row a) or any reasonable formula into the pivot table "__ Difference From" functionality without VBA?
    • trprof
    • Thread
    • % difference from difference ln function pivot table vba
    • Replies: 1
    • Forum: Excel Questions
  3. T

    How to change "% Difference From" to "LN Difference From" without VBA?

    in Excel 2010, how to (or is it possible?) to change "% Difference From" to "LN Difference From" without VBA? That is embed LN( row b / row a) or any reasonable formula into the "__ Difference From" functionality without VBA?
    • trprof
    • Thread
    • % difference from difference excel 2010 pivot table vba
    • Replies: 0
    • Forum: Excel Questions
  4. K

    Pivot Table - Show Value As - Hidden / Visible Row

    I have two pivot tables, both tables have dates in one column and other column is the % difference from the top oldest date. I added a slicer to control both pivot table dates which works fine. Say the slicer is currently on 1/1/2017 and the prices are show % difference from 1/1/2017, now when...
    • kangi24
    • Thread
    • % difference from hidden row pivot table 2016 show value as visible row
    • Replies: 0
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top