05-28-2015 07:27 PM
I was just wondering whether I can have dynamic column header for SAS VA report.
If I run a report in Jan my report will look like
|Numbers in 000's||Jan||Feb||Mar||Apr||May||Jun||Jul||Aug||Sep||Oct||Nov||Dec|
|# of Accepted||6790||679-||23||90||69.0||269||29.9||2||27||21||27||20.9|
And if run in Feb then the Feb column header has to change
|Numbers in 00000's||Jan||Feb||Mar||Apr||May||Jun||Jul||Aug||Sep||Oct||Nov||Dec|
|# of Accepted||356||3||31||26||26.0||26||26.9||2.8||270.3||20.1||27||279|
06-08-2015 08:45 AM
To attain the obove requirement, you have to create a calculated Item and them custom category on calculated item.
1. Create a calculated Item:-
IF ( Month(Time) > Month(DatePart(Now())) )
where "Time" is the date measure. Let us say the name of this calculated item is "Calculated Item (1)"
2. Create a Custom Category based on the calculated Item that we have created above "Calculated Item (1)", let us name it "Custom Category 1" :-
Create label "Actual" with value of "0.00" and "Projected" with value of "1.00".
Now you can use the created "Custom Category 1" in crosstab as column role to attain the required report.
Hope this helps you.
06-11-2015 02:16 PM
Thanks for your response.But what I was looking to change the column header label.
I will have measure for each month (12 column for each month) and till current month coulmn I want to have an Actual and for upcoming month measure should have the projected
06-12-2015 02:03 AM
I think so it is possible to attain the above requirement once you make all these 12 measures(months) into one category may be named as "Months" which can be achived at the stage of data preparation.