6 Replies Latest reply on Sep 26, 2018 10:59 PM by Anuj Transit

# Calculate a percentage of Sum out of 100

Hello Everyone

I have datas of order menu taken by Handy and Touch Panel.

Its values are

ProductsHandyTouch Panel
Coffee15366
Drinks382
Cappuccini734
Cake191
Desserts140

Here I want to calculate the percentage of total sum and display without actually showing up sum table, Just a percentage table.

How do i do it.

For now I did on excel by adding up and taking percentage.

+ I will I want to show it on graph of 100% Like 20% of 100 and so on...

• ###### 1. Re: Calculate a percentage of Sum out of 100

Hi Anuj,

If I am getting you right, do you wish to see something like this?

• ###### 2. Re: Calculate a percentage of Sum out of 100

Hi Anuj,

~Tushar

• ###### 3. Re: Calculate a percentage of Sum out of 100

This is the screenshot from my original post.

Here you can see the red one is from Touch panel and orange is form Handy .

1st one is coffee and its Touch panel sum is 366 and handy is 15 .

So How can i calculate the percentage and show display out of 100% .

• ###### 4. Re: Calculate a percentage of Sum out of 100

+ How Do i Change this axis to 100% instead of just 60% . ?

• ###### 5. Re: Calculate a percentage of Sum out of 100

Right click edit axis and select Range -> Fixed -> 0 to 1

1 of 1 people found this helpful
• ###### 6. Re: Calculate a percentage of Sum out of 100

Can I also ask . How do I sum of between two items and show the percentage of the total.

Screenshot

Here at 1st bar

We can see red = 1756 and orange = 50

So the total sum is 1756 + 50 = 1806

Now percentage of Red = (1756/1806)*100 = 97.23%

Percentage of Orange = (50/1806)*100 = 2.76%

Here I want to calculate and show 97.23 and 2.76 on respected color red and orange.

How do i calculate it ?