• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Differences between two pivot tables

T

Tristan Shannon

New Member
Hi there,

I've been trying to compare two pivot tables and get a variance between figures in the two. I can do it by using the getpivotdata by subtracting one total from another but I need a dynamic way of representing this as we are comparing multiple projects. I have attached the tables and data I have been using. I need to compare two different categories relating different names to each other such as
Ali Jamb -----> Aluminum Jam
Alluvium Contracting -----> Excavations + Drainage
Baseup --------> TC2 Ribraft

Any help regarding this would be much appreciated as I am well and truly stumped
 

Attachments

Hi:

What is the connection between the two data sets? As per me both pivots are from stand alone data sets. You will have to establish a link between the suppliers and the type of the services they provide in order to calculate the variances. On the sheet1 column A is not supplier, but the service they provide, if you can make a master database with the suppliers and the type of the services they provide you can link both the data sets using formulas and pull the variance in one pivot itself.

Thanks
 
Thanks for your help. The connection between the data is column A is the actual cost for a project and column C is our estimate. So for each item in column C we want to compare it to the items in Column A to see have far out our estimates are. It will be hard to put both data sets in one pivot as column A is coming from accounting software and column C is coming from a pricing spreadsheet. I was thinking there might be a vlookup type function that could connect the names together such as if I select Ali Jamb it automatically looks up aluminium jam and subtracts it. Is this possible?
 
There's really nothing that ties data from Sheet1 to Raw Data (i.e. UID or multi-column criteria). You can look at overall variance from estimate to actual cost only from current setup.

Which can be achieved via simple SUMIF/SUMIFS formula on two tables.
 
You must log in or register to reply here.
Back
Top