Hi,
if you want to compare different fact values (actual and budget) you have to load them into ONE fact table.
You can achieve this by concatenate (table) load
In your case, you have actual on customer an target on territory. This won't work by concatenate only.
So you have to load actual, join territory by customer into actual table and then concatenate load target.
then you will have one table with
date
customerid
territoryid
actual
budget
and you can create a chart with actual and target by territory.
Regards
