Skip to Main Content

How to Find Max Row Count for union reports

Rookie_86Oct 16 2012 — edited Oct 16 2012
Hi,

Obiee -10g.

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 ?

Thank you.
Comments