bigburge10
New Member
- Joined
- May 13, 2015
- Messages
- 10
Hello,
I have two tables in Excel 2013: Actual & Forecast. Both tables have the following similar columns: Period, Account, Amount. I've included them in a Pivot Table Data Model and would like to calculate a variance between Actual[Amount] and Forecast[Amount]. I'm unable to utilize the Calculated Field/ Item since those aren't available when using a Data Model.
Both tables are related to 2 other tables: Period & Account--both of these tables provide additional information for these fields (Account Hierarchy, Period Intelligence, etc).
How can I perform such a calculation? It seems like such a simple thing, yet I can't seem to figure it out!
Thanks in advance, and please let me know if any additional information is needed.
I have two tables in Excel 2013: Actual & Forecast. Both tables have the following similar columns: Period, Account, Amount. I've included them in a Pivot Table Data Model and would like to calculate a variance between Actual[Amount] and Forecast[Amount]. I'm unable to utilize the Calculated Field/ Item since those aren't available when using a Data Model.
Both tables are related to 2 other tables: Period & Account--both of these tables provide additional information for these fields (Account Hierarchy, Period Intelligence, etc).
How can I perform such a calculation? It seems like such a simple thing, yet I can't seem to figure it out!
Thanks in advance, and please let me know if any additional information is needed.
