How to ignore data if no value is present

[#1]

I have 3 years worth of data to display; but only where data is present.

So sales figures for 2011 departures, 2012 departures and 2013 departures.

Data is displayed for agents even if value in the 3 columns above is at £0 / 0 presently ........

Whats the best way to supress the data from being displayed for agent records where values are £0/0 in all 3 columns  ?

Script, dimension or at each expression?

[swuehl]

If your sales data is numerical, formatted with a currency symbol, you could try just enabling option "suppress zero values" in presentation tab of chart properties.

This does only work if all your chart expressions result in zero for that row.

Stefan