Is it possible to create a filter which restricts certain metrics.. example, numbers can only appear on the chart if impressions are greater than clicks?
You would need to create a calculated field something like:
if sum([impressions])>sum([clicks]) then sum([your value field]) end
And use this instead of your value field on the shelf.
Retrieving data ...