I have joined some tables with orderid as the common element in them and I filtered my report based on the condition of cancellation of orderstatus in 'order' table.

There is another table called 'persons' with personid and orderid. I am in need of the total count of personids.

If I join persons table with order table. Then I am getting the count of personids when orderstatus has got cancelled.

I do not want the count of personids when orderstatus got cancelled, but I want the count of personids irrespective of orderstatus.

Entire report is based on the cancellation status.
But i want one particular formula which should give the total count of personids without considering the orderstatus of cancelling.

can anyone help with it.

Is it possible to use that obtained value of subreport in the calculation of other formula in main report?