Earlier in this chapter, we went through an example to take advantage of Conditional Formatting. This option can be found by hitting the downward arrow next to a field that is being used in a visual. Within this area is where we will find another option that is labeled Show Value As. This option will only be available for numeric data types, and allows us to show the values as a percentage of the grand total. The best way to take advantage of this is to place an identical column side by side and then use this option to display one of them as a percentage. For our example, lets revisit the Matrix visual we created for the Tabular Data section. Locate the Profit measure in the Fields Pane and drag it into the Values section for the visual, and place it directly after the Profit measure that we already had in place, referencing Figure 5-24. The visual looks a little odd since there is a duplicated column, but lets change it to show a percentage. Within the dropdown for the second representation of Profit, choose the Show Value As option and select Percent of Grand Total. The Matrix was already a great visual to quickly see a lot of metric information about the Sales Territory Regions, but now we have a firm understanding of what percentage each country is contributing to the grand total: