topic Re: Using Measures across rows and columns on Crosstabs in SAS Visual Analytics

Using Measures across rows and columns on Crosstabs

Suhas_77 — Mon, 17 Apr 2017 07:24:48 GMT

Hi,

I am new to SAS VA and working on a requirement to create a report which looks something as follows :

The problem I am facing is both the rows and columns will be measures. The column measures subtotals will be shown in the Overall total row. Each intersection of row measure should show the count/sum of the row measure value by the column measure values.

Following picture shows a sample subset what I would like to create :

Its not that I have to do it on a crosstab. Any other solutions are welcome. Thanks.

Re: Using Measures across rows and columns on Crosstabs

JRoman — Fri, 16 Feb 2018 02:46:39 GMT

I recognize that this is an old post, but it was never answered and I'm facing the same problem right now. Does anyone have a solution for this?

Re: Using Measures across rows and columns on Crosstabs

Gregor_Herrmann — Mon, 19 Feb 2018 15:05:23 GMT

In Visual Analytics 8.2, it is possible to place measures in rows in a crosstab object (see the attached screenshot).

Gregor

Re: Using Measures across rows and columns on Crosstabs

JRoman — Mon, 19 Feb 2018 15:07:59 GMT

Thanks, Gregor. We're still on 7.4 at my office, but it's good to know that option is available in 8.2.