03-08-2018 12:04 PM
In SAS Visual Analytics, how do you display the percent of a whole and still allow it to be drillable.
For example I have a
Hierarchy: Peer group >> institution
I need to be able to display the % of employees at any given point of the hierarchy and by rank.
03-08-2018 12:46 PM - edited 03-08-2018 12:47 PM
1) Create an Aggregated Measure i.e., Employees Bygroup / Employees Forall. Then Change the column properties to Percent.
2) If you are using Cross Table then you can create Sub Total.
03-08-2018 01:32 PM
I like the concept. When I select two institutions at the same time my percents are split between the institutions rather than percent per institution.
Need further help from the community? Please ask a new question.