Forum Discussion
Reporting Performance to Target
Dear Community, Hope my message finds you well and healthy! I am reporting performance to target on a monthly basis like shown below: As you can see my target must be below 4%, everything a...
I managed to do it. Please see below:
1. I created calculated column only for my past due balances.
2. After that another one I named "Fraction of the Overdue" with few nested ifs. If month =9 then overdue column * 0.055, if month = 10 then overdue column * 0.05 etc.
3. I created 3rd column dividing the Fraction of the Overdue to the Overdue column.
4. Put it in the pivot table, but summerizing the value to Average
5. Done.
This is how my pivot looks now. Exactly as I wanted it.
negi007 I would really want to thank you for your guidance and support.
Wish you nothing but the best.
Take care and stay safe.
All due respect,
Atanas