Hi, Winnie, and welcome to BOB!
I’m not quite sure what you are doing now – but if you are bringing back all of the data, and then applying a filter to only see part of the data, you could use the NOFILTER() function in your Item to Date variable.
You might need to combine that with the use of SUM() … WHERE. You can look here in our Reporter FAQ for how to use this Reporter clause.
Anita Craig (BOB member since 2002-06-17)