on 05-21-2012 11:49 AM
Dear Experts,
We are running sales report for Bex Web for certain period and wish to display top 20 sales by customer. Please advise us how to display such report with the complete data including the rest of data based on the selections. Currently we can display the report however it just only displayed the top 20, the rest was not displayed, as it contains a lot of data.
Regards,
Rudi
Hi Rudi,
You have to write a predefined filter that contains calculated measure computing the ranking for a given dimension and a given measure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rudi,
Did you try to apply sorting on the column ? A ranking will not fit your requerement, because you want the rest of the data to be available.
Regards
Arijit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rudi
do u want to display the Top 20 data + the data based on user selections????
Regards
RR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I did not get your requirement.
Do you want to display top 20 by customer or do you want to show all the data depending on the user selection?
Thanks,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.