Build and customise table calculations - moving and window averages, percent of total, running total, difference and percent difference, percentile, index, and ranking.

How does a Percent of Total table calculation differ from a Running Total table calculation when both are computed across the same dimension?

• APercent of Total accumulates each value onto the previous ones, while Running Total expresses each value as a share of the partition's sum.
• BPercent of Total divides each mark by the total of all marks in the partition, while Running Total adds each mark to the cumulative sum of the marks before it.check_circle Correct
• CBoth produce the same final value in the last cell, because the cumulative sum and the share both reach one hundred percent at the end.
• DPercent of Total can only be computed down a pane, whereas Running Total can only be computed across a table.

Why A is wrong: This reverses the two definitions; accumulation is what Running Total does and the share-of-sum behaviour belongs to Percent of Total, so the labels are swapped.

Why B is correct: This states both mechanisms correctly: Percent of Total normalises each value against the partition total, and Running Total carries a cumulative sum as it moves across the addressing direction.

Why C is wrong: The last Running Total cell equals the partition's full sum as a raw figure, not a percentage; only Percent of Total reaches one hundred percent, so the values differ.

Why D is wrong: Both calculations let you choose any addressing direction through Compute Using; neither is locked to a single direction, so this restriction is invented.