02-28-2018 05:13 AM - edited 02-28-2018 05:14 AM
I am creating a table in EG with below columns:
Metric Name, Current Month Target, Actual score Current Month, Actual score Month1, Actual score Month2, Actual score Month3, Actual score Month4, Actual score Month5, Actual score Month6
where Current month is the running month, month1 ....2....3....6 are previous months.
How can I dynamically change the Column names to Jan, Feb, Mar in the Dashboard that I m creating in SAS VA.
Please Note : The columns names must change based on the running month.
Thanks in advance,