If we load budget details to main expenses and would like a view of budget vs actuals based on the roll up of sub expense, does anybody know how we can get it. For e.g. our budget is loaded to main expense heads like Travel, Entertainment, etc. Travel has 3 sub GLs , similarly with Entertainment. Budget vs actual is showing the entire amount as a variance in the Travel roll up and the other amount are shown below as variances. Is there anyway, we can make it roll up?
e.g
budget actual Variance
Travel 1,00,000 - 1,00,000
-Local Travel 30,000 -30,000
-Intnl Travel 50,000 -50,000
Would like the following view...
budget actual Variance
Travel 1,00,000 80,000 20,000
-Local Travel 30,000
-Intnl Travel 50,000