How do I insert data from a field using 2 different date parameters

[Former Member]

Example..

I want to have for example product (Bronidox 1160) display data for 1/1/16-6/30/16 and also data for 1/1/17-6/30/17.

[Former Member]

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