OK. Here you go.
1. For YTD Revenue per person, you should not use the monthly colors calculation. You have to create a new colors calculation for yearly based on YTD utilization.
2. If you need to change the color of the grand-total, you need to make change to the above formula as shown below, and then set the color accordingly.
3. To center the text in the grand-total column, please remove the blank from the label.
All the above changes have been made and here is the final output.
The workbook is attached. Hope this helps.
1 of 1 people found this helpful
Your [Utilization] calculation is not designed to total properly. As a result, your utilization numbers are extremely high in the totals column, causing almost everything to go into the green.
Your denominator attempts to total the number of available working hours over the period, but it also attempts to prorate the current month. Consequently, you need to evaluate each month separately, then add them together. This calls for a Level of Detail (LOD) Expression.
I modified the calculation like so:
Compare the results (which I've thrown into the tooltip):
I've attached my workbook, but it's in version 10.3, so you may not be able to open it (sorry).
I hope this helps.
It was our intention to capture the utilization up to the day, so thats why its doing that for the current month.
Thank you Hari.
You are welcome.