Hi,
I am trying to create an additional measure that shows the % share of Cumulative Incremental Sales by Channel and cal_dt. Right now my Incremental Sales and Cumulative Incremental Sales work as expected. The formla for Cumulative Incremental Sales is below:
Aggr(RangeSum(Above(Sum({<type-={'Control'}>}sales), 0, RowNo())),channel, (cal_dt, (NumericCount)))
How do I create a measure that will show the % of Cumulative Incremental Sales for each channel (compared to total) for every cal_dt?
