Focal Point
Top 5 customers

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9547041126

June 11, 2012, 10:44 AM
Shilpa Bharadwaja
Top 5 customers
Hi,
I have a report requirement report output in excel.The Total Sales by Category (like National,Regional,Government) and further when we drill down the report should display top 5 Customers only. I plan to create this report in Developer Studio.

Can somebody suggest how to get the top 5 customers ?

Thanks
SS
June 11, 2012, 10:48 AM
Prarie
TABLE FILE CAR
SUM SALES 
BY HIGHEST 5 SALES NOPRINT
BY CAR

END



In Focus since 1993. WebFOCUS 7.7.03 Win 2003
June 11, 2012, 10:49 AM
rfbowley
try searching the online help for:

Restricting Sort Field Values by Highest/Lowest Rank


and all will be revealed


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001