Wednesday 13 August 2014

OBIEE - Display Row Number(Serial Number) in Pivot Table Report

To add row number to your analysis, You have to follow the below steps:

Step no: 1

Add the required columns to your report with one additional column (Any column).








Step no: 2

Select 'Edit Formula' from the additional column.
























Step no: 3

Edit the 'Column Heading' with the relevant name and replace the Column Formula value with 'Rcount(1)'


















3 comments:

  1. Thank you very much. This really helped me take a count of my order entries.

    ReplyDelete
  2. Hello, I have a question: I need a progressive number in my report so I use RCOUNT(1) but I have a prompt that filters the records so the result is a non continuous progressive number that goes from 25 to 29 for example ... Is it possible to make sure that the progressive number is subsequently assigned to the prompt filters? the BI version is 12c (12.2.1.1)

    ReplyDelete