Show Values As

An option in Value Field Settings that displays a value as a share or comparison instead of a raw number, for example % of Column Total (Office is 43.82% of total income). Other options include % of Grand Total, % of Row Total, % of Parent Total, Difference From, Running Total In and Rank.

When to use

Pick the option that matches the question: a % of Column Total column adds to 100%, while % of Row Total adds to 100% across each row.

See Lec 07.

Appears in

No references yet.