VA crosstab report transpose a row group

[ChrisWu]

Table 1 is a VA Crosstab Report 

I wish to get the resulting following Table 2a and 2b

1) How can the TIME_PERIOD2 be transposed such that CA_FORM_SUM is assigned as Year1, Year2, Year3?

Thanks,

[akulkarni]

I can think of two ways to do that.

1. In the crosstab properties, you can have TIME_PERIOD2 as a column and it will categorize your measures. The problem is all your measures will be categorized by TIME_PERIOD2.

2. Another option is to create calculated items for each year. For example, IF TIME_PERIOD2 = YEAR1 then 'Year 1' = CA_FORM_SUM ELSE 'Year 1' = 0

Hope this helps.

[ChrisWu]

ok,.. my findings

Option 1: Select and activate the Chart, then Right-side Bar> Data Role to move Data Item to Columns;

Option 2: New Data Item > Calculated item > text: Does Not understand SAS code 😞