1 of 1 people found this helpful
You can Pivot both your start and End dates. You would get Pivot Field Names and Pivot Field Values . So write 2 calcs
If Pivot Field Name="Rental Start Date" Then Pivot Field Values" End..You can Count these Dates to give you counts of outgoing
and Second CalC;
If Pivot Field Name="Rental End Date" Then Pivot Field Values" End...You can Count these Dates to give you counts of incoming
Drag these Calcs to Rows and you should be good.
This worked, thank you for the quick response.