topic Re: List/Crosstab table options: horizontal vs vertical categories in SAS Visual Analytics

List/Crosstab table options: horizontal vs vertical categories

ender111 — Thu, 22 Dec 2022 19:27:20 GMT

In a list table, the categories / measures are arranged horizontally and the individual records listed vertically, much like a typical database table. Is there a way to flip that, so the categories are listed out along the y-axis with the individual records stacking along the X-axis? I tried this with crosstabs and couldn't manage it either. Thanks in advance.

Re: List/Crosstab table options: horizontal vs vertical categories

Madelyn_SAS — Thu, 22 Dec 2022 20:02:12 GMT

In a crosstab, you can put the measures on the rows. Does that help? This is a setting in the Options pane, under Measure heading placement.

Re: List/Crosstab table options: horizontal vs vertical categories

ender111 — Thu, 22 Dec 2022 20:52:56 GMT

I see how that can be helpful, but I need a full pivot, so categories would have to be as rows as well as measures. I can't seem to get that to work.

Re: List/Crosstab table options: horizontal vs vertical categories

SASKiwi — Thu, 22 Dec 2022 21:45:04 GMT

I think you can stack categories in rows by creating a hierarchy for these categories then adding the hierarchy to the row dimension rather than single categories.