This content has been marked as final. Show 2 replies
I've got a question concerning comparing expressions of not associated columns. My set up looks like this:
Now I want to calculate, how often the sum of Column4 grouped by Column3 equals the value in Column2. I got something like
=count(Column1 = aggr(Column3,Column1))
this gets me the number of sets of Column1 which are also in Column3. But I want to get a step further and expand this expression by comparing the sums of Column2 and Column4.
Do you know what I mean? Can you please help me?
Oh, I want these columns not to be associated....
Thanks in advance