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.