Forum Discussion
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...
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
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
