Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

% of Total with Hierarchy

Accepted Solution Solved
Reply
Valued Guide
Posts: 617
Accepted Solution

% of Total with Hierarchy

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.


Accepted Solutions
Highlighted
Solution
‎03-14-2018 08:53 AM
Valued Guide
Posts: 617

Re: % of Total with Hierarchy

Posted in reply to DavidPhillips2

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

View solution in original post


All Replies
Regular Contributor
Posts: 208

Re: % of Total with Hierarchy

[ Edited ]
Posted in reply to DavidPhillips2

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

Valued Guide
Posts: 617

Re: % of Total with Hierarchy

Posted in reply to TejaSurapaneni

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.

Highlighted
Solution
‎03-14-2018 08:53 AM
Valued Guide
Posts: 617

Re: % of Total with Hierarchy

Posted in reply to DavidPhillips2

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 149 views
  • 0 likes
  • 2 in conversation