Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

COUNT of Clients whose revenue is > 5 million

Hi experts,

I need to find out the output for each of these mentioned below(All these values are calculated for a particular quarter).The requirement is that all these belongs to same report only.

All these Calculations mentioned below are based only on one Key figure REVENUE(Except Added During This Quarter)

Added During The Quarter

Revenue - top client (%)

Revenue - top 5 clients (%)

Number Of Million Dollar Clients

Number Of 5 Million+ Dollar Clients

Number Of 10 Million+ Dollar Clients

Number Of 20 Million+ Dollar Clients

Clients Accounting for >5% of Revenue

1) I need to find out the count of the clients whose revenue is > 1million(>5 M,> 10M and so on). Is there any COUNT option in query designer through which i can achieve this or is there any better way of getting the solution.

2)Revenue - top 5 clients (%)[For a particular Quarter]- ->Need to find the Revenue of top 5 clients . Add them . Divide the result with Total Revenue(from all the clients) and find the corresponding percentage.

3)Clients Accounting for >5% of Revenue[For a particular Quarter]--->Need to Calculate 5% of total revenue, Count all the clients Whose revenue is greater than 5% of revenue and display the count of such clients in the output.

Pls help me in this regard at the earliest.Thanks in advance.

Former Member
Not what you were looking for? View more on this topic or Ask a question