They want to show per Quarter/Month/Today the last figure per each period
Q2 -> 77
I attached the twbx file. there is a way to do it?
By creating a calculated field similar to the following should get the desired result:
if max([Date])=window_sum(max([Date])) then sum([Qty]) end
Then, once this is placed on the view, right click on it and select the appropriate Compute Using.
Hope this helps!