Duplicate ticket status columns in report on multiple pipelines

[Probley]

I am trying to make a pivot report to show tickets by status and pipeline, but the status columns are duplicated for each pipeline. How can I combine them in a single column? 

[Ben_M · Accepted solution]

That is because each pipeline has it's own waiting on contact status. The statuses are tied to the pipeline within the Tickets object and not to the Tickets object itself. If you wanted the property to be tied to the Ticket object you could build out a workflow and copy the value to a Ticket property not tied to pipelines and then report on the custom field to report across pipelines.

[Ben_M · Accepted solution]

That is because each pipeline has it's own waiting on contact status. The statuses are tied to the pipeline within the Tickets object and not to the Tickets object itself. If you wanted the property to be tied to the Ticket object you could build out a workflow and copy the value to a Ticket property not tied to pipelines and then report on the custom field to report across pipelines.

[Probley · Accepted solution]

Thanks @Ben_M! I was able to get it working. 

For anyone interested, I created a "Ticket Status (Reporting)" property on tickets and create the following workflow: