Skip to Content

Static List of Products Regardless of Input Control

Oct 13, 2017 at 09:15 AM


avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Anish Mahadik Oct 16, 2017 at 08:25 PM

Hi Justin,

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

Please let me know if it helps you or not.

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



10 |10000 characters needed characters left characters exceeded
Abhijit Nalekar Oct 16, 2017 at 03:11 PM


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.



10 |10000 characters needed characters left characters exceeded