You can create a column to do analysis of each row value compared to a base value.

You can insert two types of Smart analysis columns:

1. Variance – Difference between base value (row selected) and each record
2. Contribution – Percentage of each record to the base value

To insert the smart analysis column,

1. Select the cell to be used as the base value.
2. Select Insert Tab from the toolbar, and select Smart Analysis from the Cells ribbon bar category.
3. Select Contribution from the drop down.
4. The % Contribution column is inserted into the visual.

Column with % Contribution of Net Revenue

Related Links

Annotate with Notes

1. Select None from the drop down to switch off the smart analysis.