Please enable JavaScript.
Coggle requires JavaScript to display documents.
$/S/W/I % Chg = [$/S/W/I]/[$/S/W/I YA]-1 - Coggle Diagram
$/S/W/I % Chg
= [$/S/W/I]/[$/S/W/I YA]-1
.
$/S/W/I
= [Dollar Sales]/
max([WEEKS_SELLING])/[Stores Selling]/[Avg # Items]
Dollar Sales
= SUM([DOLLARS])
DOLLARS
WEEKS_SELLING
Stores Selling
= MAX([STORES_SELLING])
STORES_SELLING
Avg # Items
= [TDP ]/[Max ACV]
Max ACV
= MAX([MAX_PCT_ACV])
TOTAL_DIST_POINTS
TDP
= SUM([TOTAL_DIST_POINTS])
MAX_PCT_ACV
$/S/W/I YA
= [Dollar Sales YA]/
max([WEEKS_SELLING])/[Stores Selling YA]/
[Avg # Items YA]
WEEKS_SELLING
Stores Selling YA
= MAX([STORES_SELLING_YA])
STORES_SELLING_YA
Dollar Sales YA
= SUM([DOLLARS_YA])
DOLLARS_YA
Avg # Items YA
= [TDP YA]/[Max ACV YA]
Max ACV YA
= MAX([MAX_PCT_ACV_YA])
MAX_PCT_ACV_YA
TDP YA
= SUM([TOTAL_DIST_POINTS_YA])
TOTAL_DIST_POINTS_YA