Forum Discussion
Reporting Performance to Target
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
Anonymous
In this case you will need to create one more table for target values. let say below are two tables you have one is actual value and one is target value table. In target table mentioned value against first day of the month.
2. You create one date table, in case you do not have it like below
3. link your target and actual value table using date field
4. You can create below visual once your data is ready
Is it possible if every citizen's column is gived a target per month?