Calculation of a row value by the Grand total for that selection
I have a situation where I need to do a calculation of Allocated amount which is based on a formula like this: Hours of the employee for a particular Project divided by the grand total of hours for that employee for any selected date range and this multiplied by the rate of employment. I am not able to get the Grand Total aligned dynamically against each row so I can use it for my calculation. Basically I have a table like below:
How do I achieve this either in Beast mode or MYSql if its possible, I am not able to get the 56 total to use on my formula.
Help will be greatly appreciated.