turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- How to get the percentage of different group withi...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-03-2015 05:26 AM

Hi,

I am trying to create a bar chart in the report using SAS VA and I want to get the percentage of different group within same category. For example, I have group A, B and C. I use Year as category or the x-axis. I try to get the percentage so that if I add up the percentage for A, B and C in the same year it will be 100%. But currently the percentage will be 100% only when I add up the percentage for all the year.

Can someone help me with it? It is quite urgent.

Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-03-2015 10:37 AM

I'm not sure of a way to get the percentage of a subtotal like this in a bar chart.

For what it's worth, you can create percentage of subtotal for a crosstab.

For what it's worth, you can create percentage of subtotal for a crosstab.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-03-2015 08:04 PM

Haha, thanks Sam. I also got the crosstab one but my boss prefer the bar chart. Thanks for your reply!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-03-2015 12:40 PM

Hello Sagdec,

Use Group by option which is available in 'Roles'.

As per your data., Roles are...

Category : Year

Measure : Some X or Percentage.

Group (by) : Group.

Hope this helps you...

Let me know..

Thanks & Regards,

Teja Surapaneni

Use Group by option which is available in 'Roles'.

As per your data., Roles are...

Category : Year

Measure : Some X or Percentage.

Group (by) : Group.

Hope this helps you...

Let me know..

Thanks & Regards,

Teja Surapaneni

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-03-2015 12:53 PM - edited 12-03-2015 12:54 PM

Hi Teja,

The trouble is, the percentages are based on the full data and not the subgroup:

There doesn't seem to be an easy way to get these group subtotals in a barchart.

Sam

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-04-2015 03:01 AM

Hello Sam,

I got it.., I agree with u..

Teja

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-03-2015 08:03 PM

Hi Teja, if I put percentage as measure it will show percentage of total not subgroup. But thanks for your reply!