2 Replies Latest reply on Oct 22, 2018 6:46 PM by mac lai

# To calculate percent for each content on the bar

Hi All,

I would like to know any formula i can use to auto display the % of each Reason  in "Sheet 2" that translate into the total Sale % of the period on "Sheet 1", example

my Period 18-42 Sale % is 2.34%

then Sheet 2 on bar 18-42 will have

• Low Quality = 3/32 * 2.34 = 0.22%
• Not Nice = 1/32 * 2.34% = 0.07%
• Not Popular = 13/32 * 2.34% = 0.95%
• Others = 9/32 * 2.34% = 0.66%
• Rotten = 5/32 * 2.34% = 0.37%
• Too Expensive = 1/32 * 2.34% = 0.07%

Added all the total = 2.34% for 18-42.

Thanks.

• ###### 1. Re: To calculate percent for each content on the bar

Hello mac,

Please try the following steps.

1. Select CNT(Sale Count)

2. Place [Reason] on Color mark, CNT(Sales Count) on Tooltip mark

3. Select "Quick Table Calculation" for CNT(Sales Count).

4. Change "Compute using" to "Table (down)"

Regards

Lei

• ###### 2. Re: To calculate percent for each content on the bar

Yes, working perfectly .. thanks a lot