COUNT of Clients whose revenue is > 5 million
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.