What function would be used if you want to compare all other rows with the first row?

Use the Difference From option to compare each row’s value with the value in the first row. It shows how much each other row differs from that reference row. SUM adds values, Percentage of Total shows proportions, and a PivotChart displays data visually.

AI-written and checked against the verified answer.