Exclude values from a chart

[#1]

Hi all, beautiful day here in London today.

Is there an easy way to exclude a single dimension value from a chart? For example, I have a chart showing currency balances by date. The data runs from 31/12/2009 up to today, but I only want the chart to display balances for this year.

I guess I could add a 'Year' field based on the date and then just select 2010, but I'm just curious to know if there is a way I can choose to exclude a value from those available in a list box?

TIA

Tony

[#2]

hi,

probably you can use set analysis

sum({1<year={2010}>}balances)

thanks

[#3]

Thanks Tauqueer, that's what I suspected. I guess I was hoping for a right-click menu option to exclude the selected item.

Maybe a request for v10.....

cheers,

Tony