You need to sign in to do that
Don't have an account?
Dynamic labels on report columns according to month
There are some fields in Lead object; namely
1 month prior value
2 month prior value
3 month prior value
and so on...
Now the users want to extract out monthly reports but want the fields displayed out in a dynamic manner:
Suppose, we are running the report in August,
the fields should be displayed as:
1 month prior value ----> July value
2 month prior value ----> June value
3 month prior value ----> May value
and so on...
When running the report in December,
and so on...
the fields should be displayed as:
1 month prior value ----> November value
2 month prior value ----> October value
3 month prior value ----> September value
and so on...
They somewhat like to have dynamic labels according to the month they are generating the reports.
Please if anyone has any clues; I'll be grateful to you.....
Thanks,
S