- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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 😞