cancel
Showing results for 
Search instead for 
Did you mean: 

Top n in condition report

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Rudi,

You have to write a predefined filter that contains calculated measure computing the ranking for a given dimension and a given measure.

Former Member
0 Kudos

Hi All,

Thanks for your reply. Yes i need to display top 20 data + the rest of data based on user selections, but the rest of data is not displayed.

Hi Ravi,

what do you mean predefined filter, we created the condition through query designer, as you can see below:

Please advise.

Regards,

Rudi

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Rudi

do u want to display the Top 20 data + the data based on user selections????

Regards

RR

vinay_lohakare5
Contributor
0 Kudos

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