Top 10 and Total in a single Report — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Top 10 and Total in a single Report

Received Response
2
Views
2
Comments
3193829
3193829 Rank 5 - Community Champion

Hi ,

I have requirement of a report which should include the following

1) top 10 customers and their profit.

2) Below it total Customers(100)  profit

3) Below it Total customers - Top 5 cutomers Profit (other customers)

4) Todays profit - ydays profit

5) Todays profit - previous 7th day profit.(weekly difference)

I was not able to put, top 10 and  total customers into one report. Am i missing something? I am doing a report for Top 10 and another for 2,4& 5 seperatly.Not sure of calculating Other customers.Please help

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    For your report 1,  3:

    1. What i recommend is to use a different object analysis by each report that you have because you have to use different filter by each report, to get a "clean" solution.

    Filter:

    Report1 : Rank(Measure Profit) < 10

    Report2 : Rank(Measure Profit) < 5


    2. In other hand, that you want to show TOP RANK CUSTOMER 10  and OTHERS Rows check this link : OBIEE TopN versus the rest : Total Business Intelligence

    and do the same for 5 RANK CUSTOMER, create a two different pivot table views to show both of the RANK 10 / 5.

    For your report 4,5 :

    1. Use a Times Series Function report 4 (its no clear to me) but you say that you have  YEAR TO DATE Report? Use TO_DATE Function,

       Compare weekly difference AGO Function.

    Kind Regards,

  • 3193829
    3193829 Rank 5 - Community Champion

    Hi Cesar,

    Thank you.

    Right now i implemented 1 to 3 in the same report and 4 and 5 in a separate report. I still need to work on the report.

    Regards,

    Kalpana