BookmarkSubscribeRSS Feed
anandsasbi
Obsidian | Level 7

Please look attached file for build clear understanding on my question .

I want to create a cross tabulate report with following requirement (SAS Visual Analytics requrement).

1> can i use different column group under one column hierarchy. ex. In column hierarchy (level 1) have three category value Group1,Group2 and Group3…  group1 have used measure ( col1,col2,col3,col4) in same way Group2 have (col5,col1,col2,col6) and Group3 have (col5,Col1,col2,col3).

2> can we define blank space as gap between column and row

3> can we merge two column header or hide any column header,,

4> can we use character value in Cross tabulate report as column value.

5> can we display up and down arrow sign with different color as indicator or sticker in numeric column based on condition.

 

 

Thanks in advance 

Regards 

Anand

 

 

 

 

 


my SAS VA Question.png
2 REPLIES 2
Renato_sas
SAS Employee

Hi Anand,

 

I'm afraid the answer to all of your questions, except #5, is no. Fine control like you get from spreadsheets is not possible. For #5, you can do that by defining Display Rules, on the right hand side of Visual Analytics Designer.

 

Best,

Renato

anandsasbi
Obsidian | Level 7

Thanks Renato for your reply. but it's my client requirement.   

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 899 views
  • 0 likes
  • 2 in conversation