Forum Discussion

natasha519's avatar
natasha519
Icon for Helper II rankHelper II
4 years ago

How to calculate proportion

Hello, I am using a matrix to create a heat map (used conditional formatting for background) so each cell has a different number of documents. How can I show the proportion as well? For example in t...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

Hi natasha519 ,

 

If I understood you correctly, you want the percentage to show on the data?

You can put again the value and the right click, show value as then choose percent of grand total

 

Hope this helps

  • natasha519's avatar
    natasha519
    Icon for Helper II rankHelper II
    4 years ago

    I tried this, but am not sure what it is showing the percent of grand total of. When I divide the number that's currently displaying by total I am not getting the correct percentage