0 Replies Latest reply on Jul 9, 2016 12:24 PM by AbinashBehera

    Rank and Count function in Obiee 11g

    AbinashBehera

      Hi All,

      I got a requirement which I am facing issues while implementing, Please find the below details: Suppose I have the below table, where there two groups, group1 and group2, Each group is having three category, A,B, C . and their members business. Shown In First Table

       

       

      GroupsCategoryMembersBusiness
      Group1AM11000
      Group1AM22000
      Group1AM31500
      Group1AM42500
      Group1BM53000
      Group1BM63500
      Group1BM74000
      Group1BM84500
      Group1CM95000
      Group1CM105500
      Group1CM116000
      Group2AM124000
      Group2AM134500
      Group2AM149000
      Group2AM158500
      Group2BM161000
      Group2BM172500
      Group2BM183500
      Group2BM193000
      Group2CM207000

       

      -------------------------------------------------------------------

        But The Report should be like this(without Members). But I have to consider the top N(as per user input) members(based on their business) from the first table. till now there is no difficulty

      GroupsCategoryBusiness
      Group1A7000
      B15000
      C16500
      Group2A26000
      B10000
      C7000
      Total Result
      81500

      -----------------------------------

      Now the difficulty I am facing while adding the count of members in the respective Group and Category after the Top N filter Applied.

      So the Actual Report Output should be as below, with Top 10 as input.

       

       

      GroupsCategoryMember CountBusiness
      Group1B28500
      C316500
      Group2A426000
      C17000
      Total Result
      1058000

       

      -------------------------------------------------

       

      Thanks,

      Abinash