I have a report with the following fields and calculations
And i have two totals one on the estimated amount and the other on the awarded amount for every change in the Quarter and two more Grand totals on the Estimate and awarded amount.
Quarter Month Estimate_Amnt Awarded_ Amnt
Q1 JUL $1000 $800
AUG $2000 $1800
SEP $500 $300
Now i want to create a new calculation like the following:
Q1(ESTIMATE TOTATAL)/Grand (ESTIMATE TOTAL) for each Quarters Q1,Q2,Q3,Q4. Please any advice or help is greatly appreciated.