Hi all,

I'm struggling to build a table for a dashboard. I'm trying to split the total calculated budget by "object the metric flowed through" and show this in a single table.

Say I have the current simplified model :

The easiest thing I've managed to do is use the budget driver in the formulas to create the following table :

This is already great and pretty powerful

What I'm trying to do is go one level further into the analysis by obtaining the following table:

where

1. CC1 part 1 = costs that come from Source 1 and then Object 1
2. CC1 part 2 = costs that come from Source 2 and then Object 1

I know how to independently get CCA part 1 in a separate table (e.g. table on Applications filtered on something in Source 1) but how could I get everything in a single table?

Thanks in advance,

David