Static List of Products Regardless of Input Control

[Former Member]

Hello All,

I'm working with 3 objects described below:

Product Line - A category of products

Customer - The customer who buys the product

Current Year Extended Price - Current year sales

I'm trying to setup a table of top product lines across all customers, essentially a top 10 product line table. I would like this list to remain static regardless of which customer I select on an input control. However, not all customers have made purchases in every product line. So when I look at the top 10 product line list for my entire customer base, it shows the 10 product lines I want to see. As soon as I select a single customer via input control, a few rows of product lines disappear because the "Current Year Extended Price" for that customer, for that product, is null.

I've tried setting up a variable "=1+[CurrentYearExtendedPrice]" but that has not helped. "=If( IsNull([CurrentYearExtendedPrice]);0;[CurrentYearExtendedPrice])" did not work either.

Is there any way I can make the product line list static, regardless of customer selection or sales?

[former_member182342]

Hi Justin,

Please see all below links for calculate top records in the report.

http://www.forumtopics.com/busobj/viewtopic.php?p=684744

http://reports.is.ed.ac.uk/areas/itservices/busintel/TrainingMaterials/advUser/Lesson3-Step3.html

https://dwbicastle.com/2013/12/11/prompt-value-based-ranking-top-n-value-report-in-bo/

Please let me know if it helps you or not.

Else provide your complete scenario so I can help you further.

Regards,

Anish

[Former Member]

Hi,

You can create a separate query to get top 10 products.

And merge the product name with main query product name object.

By doing this you will get always get the Top 10 products though there is value available or not in main query for customer.

Let me know if it is helpful or not.

Regards,

Abhijit.