02-01-2018 11:22 AM
02-02-2018 02:58 PM - edited 02-02-2018 02:59 PM
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.
02-07-2018 09:49 AM
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