locked
PowerPivot relationships RRS feed

  • Question

  • Hello,

    I have two power pivot data tabs that are very similar.  Many of the columns are the same information (refreshed from external Excel files); however, one tab is being used for 'budget' data and another one for 'actual' data so the dollar amounts differ.  I cannot set up relationships for the columns between the two data tabs as it says there are duplicate values.  How can I set up a pivot report from this data so that I can pull both the budget and the actual into the power pivot report?  And also how can I get it to calculate the variance between the two?

    This is crucial to being able to report financial results for my organization.

    Any suggestions?

    Thanks!

    Wednesday, August 15, 2012 11:28 PM

Answers

All replies