Create two formula
@Range1
If datefield >= 1/1/17-6 and datefield <= 6/30/17-6 then valuefield else 0
Repeat for other date range and place in details and suppress detail section,
Group by product and then you can then perform summaries on these two formula as required.
Ian
Add comment