Hello guys!
I need some help here! Data example:
Store / Date / Stock($)
1 / 2017-01-01 / 1
2 / 2017-01-01 / 2
1 / 2017-01-02 / 3
2 / 2017-01-02 / 4
1 / 2017-01-03 / 5
2 / 2017-01-03 / 6
User selected date range from 2017-01-01 to 2017-01-02
I want to show only the last selected day sum(stock)
Stock($) = 7
I've tryed SUM( {< DATE = {'2017-01-02'} >} STOCK) and this worked, but how to do using "max_date_range variable"?
Thanks!
