Report using a Database view parent table count

[BK22]

Hi,

I have a report that pulls approvers for each Change Request using a database view, which creates a one-to-many relationship.  However, the total count includes the duplicate Change Request numbers due to multiple approvals. Is there a way to base the total count on the parent table instead?

[Dr Atul - LNG]

Hi @BK22 

I am not sure. When you create a report, use the diction [It is available in one of the report types] as a filter in the report.

[BK22]

Thank you for the reply.

Where exactly do I find it? Keep in mind I need to use a simple list report.

[Dr Atul - LNG]

Hi @BK22 

It's not available on the List report. I tried on Bar graph

[AndersBGS · Accepted solution]

Hi @BK22 ,

 no, this is not possible.