Skip to main content

Hiyo, 

 

I want to bring 3 objects into a report

Status (active or expired)

First purchase date

Expired date.

 

Basically I want active and expired to sit on top of each other in the report, and have the grouped by calendar month.

 

However, I only want this data from 01/07/2019

 

If I put the filter for >01/07/2019 on both FP date and expired date, it wont show any expired accounts that were purchased before 01/07/19. If I only put the >01/07/19 on expired, it expands the chart to first purchases back to 1998.

 

Any idea's on fun tricks that could help here?

 

Thanks

0/9000