Calculate not working when using same field in table and formula filter

Hello everybody,   I'm trying to do something very simple, but I can't make it work:  from a Sales table, I need to compare the revenue for every product category related to another one.   I've  ...