How to show group in Main rpt according to sub report group
I have created two sub reports which calculates different total jobs, I then added both of them into my main report by using a shared var formula.
The total of both reports is working fine however all the Reason Codes are being shown instead of showing only those which are matched with both sub reports (report is Grouped by Reason Code in all three reports Main-Subreport1-sub report 2).
For example in the main report it says
Where as in sub report the group reason code might be only 1,4 and 7.
What I am trying to do is to show only specific reason codes in the main report which are given in both sub reports.
Is it possible to select (or use a formula) which selects only exact match reason codes and displays it?
Please note: The main report has only Reason Code table and does not have any other filtration. All the filtration for reporting happens at the sub report level.