Sort and Classify

Cumulative Shares

Cumulative shares show how much of total annual dollar use has been covered so far.

highlighted = computed this step

X cumulative share

After X, cumulative share is 2/5.

cum share after X=2/5\text{cum share after X}=2/5
Sorted cumulative tableSorted rows expose the cumulative share after each item.sorted use and shareusecum shareX602/5Y402/3W3013/15Z201

X plus Y

After X and Y, cumulative share is 2/3.

cum share after Y=2/3\text{cum share after Y}=2/3
Sorted cumulative tableSorted rows expose the cumulative share after each item.sorted use and shareusecum shareX602/5Y402/3W3013/15Z201

Add W

After adding W, cumulative share is 13/15.

cum share after W=13/15\text{cum share after W}=13/15
Sorted cumulative tableSorted rows expose the cumulative share after each item.sorted use and shareusecum shareX602/5Y402/3W3013/15Z201

Add Z

After Z, cumulative share is 1.

cum share after Z=1\text{cum share after Z}=1
Sorted cumulative tableSorted rows expose the cumulative share after each item.sorted use and shareusecum shareX602/5Y402/3W3013/15Z201