I have a contract table and want to count the total number of contracts by contract template. But I want to keep this count despite of other filters I apply.
So let's say the count of contract template 'CONTRACT A' =100, I want to keep this 100 when a user filters on other dimensions which would normally lower this number.
I've tried to use Set Analysis but it looks like I have to use specific strings..
Thank you both for your replies. The first expression makes my application crash.. Maybe because of the number of records and the complexity of the expression.. The second expression (count({1} Contractnr)) works, it counts the number of contract for each template whatever I select. The only problem is that it keeps showing all the contracttemplates, even when I select one specific template.
Is it possible to use this expression but enable filtering the templates?
that's possible but it's a little bit complicated also. You have to add all fields into the expression except the Contract, for my example the sentence would be:
