Top 10 and Total in a single Report

Question

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

3193829 · Answer

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

cesar.advincula.o · Answer

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,