Tuesday, November 17, 2015

OBIEE - Display Row Number(Serial Number) in Pivot Table Report or Table Type 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)'






Posted by at
Labels:

6 comments:

  1. UnknownSeptember 7, 2017 at 2:16 AM

    Need help in a different case.
    I want to just show index for output row in report but rcount shows count of rows for each retailers.
    so Instead of 1,2,3,4,.... I get 1,43,56,74,98,145,......

    Can you help with this.

    ReplyDelete
    Replies
    1. UnknownNovember 29, 2017 at 1:16 AM

      This comment has been removed by the author.

      Delete
    2. UnknownNovember 29, 2017 at 1:20 AM

      I have the same problem.
      Have you found solution?

      Delete
  2. kartheek.dachepalliSeptember 8, 2017 at 2:38 AM

    Can you explain more about your problem. A screenshot can help me understand better

    ReplyDelete
  3. UnknownSeptember 17, 2017 at 6:51 AM

    I cannot give a obiee screenshot.I can show you a sample in excel and explain you what all I did.
    Let me know if we can chat in mail

    ReplyDelete
  4. UnknownAugust 11, 2020 at 10:52 PM

    You should first in edit formula enter RCount(1) and in result tab right click under column and select show row level grand total and select after value.

    ReplyDelete

Subscribe to: Post Comments (Atom)