Scenario: How to display only last row value in an OBI EE report

1. Create a report with the columns COUNTRY_ID, COUNTRY_NAME, COUNTRY_REGION and drop  COUNTRY_ID  again and rename it to Row num and hide this column.

Write the following expression in Edit formula of Row num column.

RCOUNT(COUNTRIES.COUNTRY_ID)

2. Apply filter on “Row num” column RCOUNT(COUNTRIES.COUNTRY_ID)=MAX(RCOUNT(COUNTRIES.COUNTRY_ID))

3. View the results it displays the last row value on OBI EE report.