Top 10 Condition and Zero Suppression

[Former Member]

I have a query that has a zero suppression turned on, so that rows/columns that have no values are suppressed.

I have added a condition to the query such that only the top 10 are displayed.

The problem is that the condition appears to be applied after the zero suppression. The result is that when the top 10 are displayed, it is displaying blank columns, as there may be values in a column, but none of them fit into the top 10 criteria.

Does anyone know how I can suppress the zero columns/rows when the top 10 condition is active as well.

Thanks in advance for any assistance.

Regards

Richard

[Former Member]

Hi,

I donot know how to achieve this with both Condition and Supress zero rows. But i think , you can use 2 conditions .One with Top 10, and other with 'columnX'( on which you define Top condition) greter than 0.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi Anil,

Thanks for the response.

Unfortunately the column(s) that are to be hidden will change depending on the data, so this will not work.

ie. if you consider a query that has products on the rows, customer across the top, and there is a top 10 condition on the net sales of the product, so I will always have 10 rows of products, but the number of columns will vary, depending on how many customers have bought that product.

Thanks again for your suggestion.

Regards

Rich

[Former Member]

Hi,

If you mean to say that you have taken Product on rows and custmers on columns, it is possible to supress zero cell for few rows. For example, if a customer comes under top 10 for product X and that customer is not at all in the top 10 for other product Y, then you may get Zero for this Product Y row under this customer.

With rgds,

Anil Kumar Sharma .P

[Former Member]

No - the zero suppression on individual cells is working fine - we have these displaying as blank cells.

The problem is when you have a customer that hasn't bought ANY of the top 10 products. When the top 10 condition is activated, there is a column that displays no values at all. I want this column to be suppressed completely, so that the customer is not displayed in the report, as they haven't purchased any of the top 10 products.

Hopefully this clarifies what I'm trying to do?

Regards

Rich

[Former Member]

Hi,

In the defination of condition, have you selected

'Evaluate the condition for' Product only.If so, instead of selecting 'Product' only , select Radiobutton on 'All characterstics in the drill down independently' . And let us know the result.

With rgds,

Anil Kuamr Sharma .P

[Former Member]

This is already set to all characteristics.

Regards

Rich