YOY change% =
IF([LY Spend]>0,
([TY Spend]-[LY Spend])/[LY Spend],
null)
RANK([TY Spend], [TY Spend], SUBSET([Masterbrand]))
[Top 10]=
IF([Rank]<=10,
[TY Spend],
"0")
It looks like you're new here. If you want to get involved, click one of these buttons!