How to Find Max Row Count for union reports
I have a report which is combination of 2 different criteria's.
But, as per my requirement i need to show Total no. of records.
I knew, that for Total no. of records : we need to do Max(Rcount(1)).
But, when i created the same as this is combination of 2 different reports.
This, column displays - 2 distinct values i.e. say 15, 35.
15 - records is the max count of report1.
35 - records is the max count of report2.
How could i acheive the max. row count ?