6 Replies Latest reply on Oct 30, 2013 2:28 AM by Libitha Thinakaran

# How to show percentage and count together

Hi everyone,

how to show both percentage and the count number together?

thanks

canny

• ###### 1. Re: How to show percentage and count together

Hi Canny,

In your bar chart axis X is CNT(No# of siblings) so you alreday has the count on axis X. You've also dragged CNT(No# of siblings) also to Text. To show percentage, just righ click on pill CNT(No# of siblings) in Mark, and select Tablea Calculation> Percent of Total

As a result you will have the bars representing No of siblings and the % as text at the end of bars.

I hope this help. If you are not able to do it by yourself, please post a package workbook to give you the solution.

Best

Ramon

• ###### 2. Re: How to show percentage and count together

Hi Canny,

I created an hypothetical data set and a workbook to show a solution to your requirement. See the attached workbook.

Best,

Ramon

• ###### 3. Re: How to show percentage and count together

Hi Ramon,

i do same thing as you , why my result is different

thank you

canny

• ###### 4. Re: How to show percentage and count together

Hi Canny,

Its because you have done a count and Ramon has done a sum..

Ramon how did u get both the labels next to each other.. I got it similar to canny, one below the other

Thanks,

Libitha

• ###### 5. Re: How to show percentage and count together

Hi Libitha,