Hi, I've been struggling with something but am sure there's a simple way to fix it.
I've got 3 different Income Statements (Actual, Budget, Projected) for multiple periods which I want to compare in one pivot table. I've linked the income and expenses from the different statements with an account number (Account) - see below. Becuase I want to compare it on one pivot table I want to be able to select a period only once and the figures must be updated. I've therefore given all periods the same field name but are getting a synthetic key becuase the statements are already linked to each other by Account. Is there a way that I can link the 3 different periods to each other without getting the synthetic key?
//Budget Income Statement
CrossTable(IS_Period, Budget_amount, 2)
[Account name] as [Budget Account name],
(ooxml, embedded labels, table is [Budget_Income statement]);
//PROJECTED INCOME STATEMENT
CrossTable(IS_Period, Projected_amount, 2)
[Account name] as [Projected Account name],
(ooxml, embedded labels, header is 1 lines, table is Projected_IS);