Calculate the Percenage Varience of Coloum “Target Sales” and enter into a new column.
First calculate the varience in a new column.
Enter the following formula-
Varience percentage = DIVIDE([Varience], [Target Sales])
Click on the Tick Box to action the function. Important, then format the new variance percent column as Percentage to show the correct values.
Image to folow.