This may be simple question, but I am not experienced with set analisys.
I would like to compare recent sales with corresponding period in the previous year. I used the set expression:
Year={$(=(Only(Year)-1))} for the previous year. However, the period corresponding to, lets say, 9-20 of June 2014 should be 10-21 of June 2013. So I need move days range by 1.
Formula Day={$(=(Only(Day)-1))} won't work when multiple days are selected. How could I force QV to display values for the period "shifted" by one day?
