+ Start a Discussion
ssssssssssssss 

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