Add filter to CONTEXT
I have a sheet where I show the number of total occurrencies and the number of females and males. So I tried to add the filter 'First Name' in Context but that doesn't change anything. If I do this, are the calculated fields I am using still correct, or should I change also my claculated fields.
This was a typical case where I was complicating things too much, and the solution was a simple IF THEN condition. So, in case someone is in the same situation, I created a calculated field
IF [Gender]='f' THEN [Occurrencies] END
to calculate female occurrencies of the name, and did exactly the same for males as well.