Beast Mode to Fix Revenue per Item at the first entry (so compare the rest)?
Imagine the following: Item Revenue (Vs 1st Entry) A 100 0 B 80 -20 C 60 -40 Any ideas on how to write a beast mode that first fixes the first entry of the rows to a constant value for all rows (then writing a companion beast mode of the variance row by row is trivial)? I've tried to SUM(SUM(Rev)) OVER (PARTITION BY Item)…
