4 Replies Latest reply on Oct 14, 2018 9:08 AM by lu.gan.2

# Change number into percentage

Hi guys,

I want to change the Total(the blue column) number into Percentage. I want to use every total number be divided by 200.

For example:

115/200=57.5%

110/200 =55%

106/200=...

109/200=...

Thanks!

Before:

After:

• ###### 1. Re: Change number into percentage

If you set your totals column to average it should give you the same result although without the % symbol

• ###### 2. Re: Change number into percentage

Good day lu.

I'd suggest a Level of Detail (LOD) expression for calculating the %.

MIN({exclude [Category]: sum([Number of Records])})/200

You may need to do some juggling to get the column order as you'd like.

-Dan

• ###### 3. Re: Change number into percentage

Please post a sample TWBX with your data. If you're using grand totals you can try the following:

https://kb.tableau.com/articles/HowTo/custom-grand-total-show-different-measure-than-table

2 of 2 people found this helpful
• ###### 4. Re: Change number into percentage

Amazing!!! Thanks!