Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help - Need to run variance calculation in Pivot table

  1. #1


    I have a pivot table that accurately reflects actual spending and forecasted spending by account for a series of organizations/departments. I am finding it difficult to insert a calculated field that will show the difference (variance) between the actual and forecast for each month.

    The table is laid out as follows I need to add a column under each month (same level as type) to run this calc.

    Month : Type(Act & Fcst)

  2. #2


    Month and Type were supposed to be indented in the message I posted to indicate they are in the columns of the table.

  3. #3


    I can get the table to calculate sum, product, std dev, etc. but no variance..

    please help!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts