Hello All,
Happy Friday!
I am trying to calculate % total for one of my report Currently the report is as follow
Dept 1 2 3 4 Total %total
AA 20 30 10 60 54%
BB 10 5 15 10 40 50%
PreYr AnnualTot
AA 30 10 50 20 110 220
BB 10 5 20 50 80 190
All these Dept and their values are in Detail section.So how do i calculate %Total for each line of department? In above example 54% ( Dept AA currvalue (60) / Dept AA preYr value (110) * 100 = 54%) So if I put develop a formula to calculate %Total and plug it in that column it will display that value for all line item but as I mentioned that needs to be calculated individually for each line item.
Any advice/help?
Thank you...
