I am looking for a way to display the distinct count of users based on the user type, in a cross tab, based on grouping displayed as a hierarchy is expanded. A user could be one of two types - and there needs to be a column for each type, for the distinct count of users of that type. Say, Type A, and Type B. Each user has a unique identifier and a type recorded, and can have multiple rows of data for each level of the hierarchy. The hierarchy in the cross tab, is: Financial Year -> Financial Year Quarter -> Residential State When the cross tab displays Financial Year, it is to display distinct count in columns for Type A, and Type B, for the Financial Year. Then, when hierarchy expands to Financial Year Quarter, it displays distinct count of Type A and Type B, for the Financial Year -> Financial Year Quarter. Then, when hierarchy expands to Residential State, it displays distinct count of Type A and Type B, for the Financial Year -> Financial Year Quarter -> Residential State.
... View more
Visualisation tools such as Tableau, allow a drop down list that is multi select, and has a text search box within it. Can this be implemented for SAS VA. The current List Control in SAS VA is not design friendly on a dashboard, as it takes up too much space, and cannot be text searched. In Tableau, a dashboard could have 10 or more drop down lists in a small area of the dashboard, because they collapse, and are useful for finding an
... View more