Skip to Content
avatar image
Former Member

Static List of Products Regardless of Input Control

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.



    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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.



    Add comment
    10|10000 characters needed characters exceeded