topic % of Total with Hierarchy in SAS Visual Analytics

% of Total with Hierarchy

DavidPhillips2 — Thu, 08 Mar 2018 17:04:39 GMT

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.

Re: % of Total with Hierarchy

TejaSurapaneni — Thu, 08 Mar 2018 17:47:40 GMT

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

Re: % of Total with Hierarchy

DavidPhillips2 — Thu, 08 Mar 2018 18:32:26 GMT

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.

Re: % of Total with Hierarchy

DavidPhillips2 — Thu, 08 Mar 2018 18:39:49 GMT

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