If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Percentage Calculation

Started by Zimbo_African_1980, 21 Aug 2019 04:48:46 PM

Previous topic - Next topic

Zimbo_African_1980

Hello,
I'm working on a report that aims to identify and count ONLY Top 20 Salesmen based on Top 20% of total Sales.

So for example, if total sales in $120 then top 20% Sales would be $24. So I want the exact count of the salesmen who made those sales.
I have tried adding a running-total on the [sales amount] , then
count(if([running total sales amt] < [20% Sales]) then ([Salesmen_ID]) else (null))

For some reason, this still gives me the count of 20% of the total number of Salesmen in general. Looking at the raw data, I should get only 5.

I hope make sense, if not please let me know.

Thanks for your time.