Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    Guest

    Default

    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)
    Organization
    Group
    Dept

  2. #2
    Guest

    Default

    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
    Guest

    Default

    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
  •