Filter calculated field

Hi,
Has anyone a solution for filtering on a calculated field. Right mouse click filter returns no results, even though I can see the values on screen?
Is it possible?

Robert

I’ve never found it overly successful - can’t remember if I ever actually managed to get it to work but I found it it much easier to get a measure adding for what I was trying to achieve as it was usually something I’d want to repeat regularly.

Hi guys,
Just updating on this. It appears there is a bug in Phocas that appears when you combine different date range formats in a calculation, and try to filter on a value. In my example, I was look ing at Sales (Current Month) versus average weekly over previous 42 days to get my free stock cover.
By changing both to day date types, I was able to recalculate and filter as I wanted.
It appears the issue lies with the ‘days’ format, and is known to Phocas.

Robert