% of Total with Hierarchy

[DavidPhillips2]

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

Category: Rank

Measure: Employees

I need to be able to display the % of employees at any given point of the hierarchy and by rank.

[TejaSurapaneni]

Hi David,

1) Create an Aggregated Measure i.e., Employees Bygroup / Employees Forall. Then Change the column properties to Percent.
Or
2) If you are using Cross Table then you can create Sub Total.

Thanks,
Teja

[DavidPhillips2]

Teja,

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.

[DavidPhillips2 · Accepted solution]

Under properties the option normalize groups to 100% handles it.  Although the scaling is off.