Hi!
I need your help as I can't figure out how to built my model in PowerPivot to allocate shared expenses.
Here is what I would like to get in a pivot table :
ActivityRegion FinYear Allocation Amount
Accounting_Region1 2013 0,45 5 310,00 $
Accounting_Region2 2013 0,45 5 310,00 $
Accounting_Region3 2013 0,10 1 180,00 $
Accounting_Region1 2012 0,50 750,00 $
Accounting_Region2 2012 0,25 375,00 $
Accounting_Region3 2012 0,25 375,00 $
You can get the model here :
PowerPivot Test
Thanks for the help!
I need your help as I can't figure out how to built my model in PowerPivot to allocate shared expenses.
Here is what I would like to get in a pivot table :
ActivityRegion FinYear Allocation Amount
Accounting_Region1 2013 0,45 5 310,00 $
Accounting_Region2 2013 0,45 5 310,00 $
Accounting_Region3 2013 0,10 1 180,00 $
Accounting_Region1 2012 0,50 750,00 $
Accounting_Region2 2012 0,25 375,00 $
Accounting_Region3 2012 0,25 375,00 $
You can get the model here :
PowerPivot Test
Thanks for the help!