This is the display rule documentation for crosstabs:
https://go.documentation.sas.com/doc/en/vacdc/7.5/vareportdata/p0i3hwaan0ivydn1cc0lzqgyqu0z.htm#n0qlkjked7o16sn1gllsvsa0azn8
You will need to create three rules. For the Yellow rule, try the between inclusive operator:
... View more
Your link is to very old documentation. This is the same topic in Visual Analytics 7.5 and I don't see that reference to a million records included.
https://go.documentation.sas.com/doc/en/vacdc/7.5/varef/p07uif0jfvtijon0zgbm5hiaqip4.htm
To see that same topic for other releases on SAS Viya, select your release from the drop-down list in the upper left.
... View more
This is the documentation for 2022.09 https://go.documentation.sas.com/doc/en/sasadmincdc/v_032/caldatamgmtcas/p1dwawsidsczlpn121j0glleicxp.htm
... View more
If you right click a measure value, you should see the option to apply a sort to each of the categories used in the crosstab.
You cannot sort on a measure that is not in the table.
... View more
Here are the system requirements for Visual Analytics 7.5x https://support.sas.com/documentation/installcenter/en/ikvisanlytofrsr/73239/HTML/default/index.html I would also suggest checking this: https://support.sas.com/kb/63/853.html And making sure that the reports are designed well: https://communities.sas.com/html/assets/breports/index.html
... View more
Are these tables exactly the same except for the actual values? So, the column names, data types, everything? If so, you should be able to Replace JAN PROJECT COUNT with the Feb table.
You should first remove the Feb table from the report.
... View more
To collapse the report control section, select the menu again, and select Collapse report controls.
The drop-down list size depends on the length of the values. Do you have some very long values? I am not sure which version you are using, but you might have Layout options that allow you to manually adjust the size.
... View more
The ability to use Visual Analytics and view reports is not the same as granting permission to the data source used in the report. Please see Permissions by Task
... View more
Open the report menu by clicking the three dots on the right. Select Expand report controls and all page controls. Any existing page controls will be visible. If there are currently no page controls, then it will look like this.
You can drag controls over, or you can right-click the object on the Objects pane and select Add as page control.
https://go.documentation.sas.com/doc/en/vacdc/7.5/vaobj/n11d8xohg1cc49n1d3ovjmgvdeu3.htm#p06zl2khxxfwern1sbc4v9w18w3d
... View more
