I am unable to copy up the pbix file that contains confidential information regarding consolidated financial statements. We have dozens of companies each with their own data set and trial balance. They share the same chart of accounts. I have a Financial Statement Template and a Measure for values. They work great. I convert to a template in order to have each company listed in the columns by using the filters for selected companies. The sample attached shows a summary of what they look like now. Works great except we need to eliminate interco accounts which are mainly AR or Equity.
There is no “Eliminations” company to slide into the model. The yellow highlighted accounts need to be eliminated on the consolidated statement. The formula is needed tp basically produce the opposite number of the total balance in each account.
Since the total is a SUM or Calculation and there is no Eliminations company summing this data, how can I get an eliminations column? Any help is appreciated!
Templates for FS - Simple.xlsx (25.7 KB)
