Excluding dimension values

[#1]

Hi.

I need to create a chart with some dimensions and measures.

For one dimensions I need to exclude some values to don't show the related measure values. For this dimension I haven't to create a list box with the dimension values. I think to edit the dimension inside the chart.

Any suggests to me, please? Thanks

[erichshiino · Accepted solution]

You may edit the dimension expression on a chart (creating a calculated dimension).

for example

if(Year>2000,Year).

Another option is to use set analysis in all your expressions in the chart to exclude dimensions that get null results.

Rgds,

Erich

[#3]

Ok, thanks, it is a good tip.