drilled out values show in listbox

[Anonymous]

Hi,

i have created a drilldown dimension with 4 product levels (from aggregation to most detailed level). When I put the dimension in a chart it is very easy to drill down, but I always have a legend that shows also excluded variables, that i do not want to see while i drill down.

I need to NOT show the excluded values both in charts and list box properties.

How can i do this??

Tx

[anbu1984]

Can you post sample qvw

[Anonymous]

Niccolò,

Inside a graph, if you use drilldown dimension and you want to avoid excluded, you need to select 'Supress when value is null' in graph properties.

On the other hand, if you have a list and your purpose is to not show excluded, you will have to use the Aggr function as I told you.

I understand you need to use both, in the graph and in the list object.

Salute.

Marc.