1 of 1 people found this helpful
I tried couple of things, but could not find if the date range with lookup(min(xx),0) is not static in both sides.
I meant, if the date range is fixed oat the end, this is one options.
Bck-calc cumulative number.
If you set both side as range, only way is to use parameter as long as I could think out.
And if I make this a bit more complicated by throwing 'Segment' into the Color tile (to make the chart stacked lines/bars)?
Definitely, adding dimension to table calc makes solution 10 times more complicated.
Bummer. The real data actually has a couple of dimensions in the mix. But thanks, anyway, and thanks for the idea of using start/end labels for the cumulative line. I'll just go with that solution.