Here is one way to do that:
- Create a template column that concatenates the values in every row of the two columns you are interested in. For example, lets say its a User table and you are interested in Age & Sex, then your template column would be something like ‘Age:Sex’, and then substitute the actual values in each row
- Next create a similar template column, but using the actual values you need to count. Again, for example, lets say you are looking for 10 year old males, then it would be “10:Male”
- Now create a multi-relation joining those two template columns
- Finally, create a rollup column counting the items in that multi-relation