Sum of Sales 6 coming months (but then from comparative period last year)

[bimotive]

Another Set analysis question I need help with.

Assumption : today = 18th of July 2016

Need:

Sum of Sales of following 6 months (but then last year or beginning of current year depening of current date!).

So I mean the sum of Sales from 1th Aug 2015 thru 31 dec 2015.

This of course has to be relative to today's date. Can somebody propose a solution?

Kind regards,

Arjen

[Frank_Hartmann · Accepted solution]

Hi Arjen,

have a look at the attached qvw.

hope that helps!

[bimotive]

Yes! thx!