Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Using Measures across rows and columns on Crosstabs

Reply
New Contributor
Posts: 3

Using Measures across rows and columns on Crosstabs

[ Edited ]

Hi,

 

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

 

crosstab question.png

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 :

 

crosstab question 2.png

 

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

Post a Question
Discussion Stats
  • 0 replies
  • 84 views
  • 0 likes
  • 1 in conversation