How to sum field from two queries in concur Report

Vrinda21

I’ve created two queries, both of which include the field Report ID, but each is filtered differently. I'm now trying to aggregate the counts of Report ID from both queries, but I'm encountering the error below.

Could someone please help me understand this error and suggest how we can perform the summation?

Thanks!

KevinD

@Vrinda21 the cross joins error leads me to believe that you pulled data from two areas in the data warehouse that don't gel. You might need to create a Union or Join report to achieve what you are looking to do.

Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.