02-24-2016 12:51 PM - edited 02-29-2016 04:02 AM
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
03-01-2016 11:50 AM
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.