combine to queries to make one report

[Former Member]

Hello,

Is it possible to combine to queries to make one report?

I have been asked to create a report to shows the settlement status of a mileage report for the last two months and also in the same report show everything that has to be settled.

I have created two queries u2013 one that shows restricts by last two months and another that restricts settlement by u201Cto be settledu201D.

I would now like to combine these two queries to create one report. However in report designer when I insert the two queries it does not allow incorporating the two to make one report. It just allows you to leave one below the other.

Is there a way I can combine the two or is there something I can do in the query designer, because as far as I know you canu2019t use dimensions twice in the columns.

Thanks

Forhad

[Former Member · Accepted solution]

HI Forhad Hussain,

Create a new query by adding all required keyfigures(settled & to be settled) using restricted key figures, instead of global restrictions.

Or enhance any of existing report by changing global restricting and adding new RKF's.

Hope it Helps

Srini