Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Top N Records by selecting Multiple measures

Status
Not open for further replies.

jonav

Programmer
Nov 14, 2011
69
US
Hi Gurus,

I have requirement to create filters/prompts for the user to select Top N/Bottom N records on the selected measures from drop down.

Scenario: I have 13 measures, Client Name and Employee Name in crosstab
User will enter values for Fiscal Year/Period.

Requirement is:
1. User wanted to Enter value to see the records (Enter 10 to view 10 records)
2. Select TopN and Bottom N records to display (ALL should be included in the list to select)
3. Select measure to see the TopN/Bottom N records (All should be included in the list to select)

Data Sources: Crystal reports 2013 on HANA/BEX query

Looking forward to your suggestions.

Thanks,
Jothi
 
Any suggestions pls???

Thanks,
Jothi
 
I have not used Top N much. But it appears you can at least set the N number with a formula which could be a prompt. The only way I think you could get either top or bottom is to have sub-reports (one for top, one for bottom, and a third for all). I believe I have created dynamic grouping before (need it for the top/bottom n to work), but it has been a long time ago.

Just some thoughts, not sure if any of this will work for you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top