Crosstab - displaying issue

[Filipvdr]

Hello again,

I got the following crosstab. But i want to see my measures on top, and my Year (annéé) below, so i can more easily compare them next to each other.

Note that my 2 measures are aggregated measures (# refsALL is a distinct count for example)

Any solutions, ideas?

Thanks in advance.

Filip

[TejaSurapaneni]

Hi, Filip

It is not possible in VA to show measures on TOP and Years in below. in my world. you have to change Data level structure...

Thanks,

Teja Surapaneni.

[Filipvdr]

So you mean create a category for the measures?

[TejaSurapaneni]

Yes,

You have to create category xyz (ref, ODS) and measures(2015, 2014) on data set level.... but it is too complicated....

Thanks,

Teja Surapaneni.

[Filipvdr]

I don't understand this is not possible within SAS VA. it's a very basic request.

Thanks for your answer, this confirms my idea.