Set Analysis Filter to filter 2 criteria

Anonymous — Wed, 22 Dec 2021 15:42:54 GMT

Hi,

I need to count data where 2 criteria to be met, 1 the Year and the Account Manager Name

i'm currently using the below to have the Account manager name filtered to count the data which is here the number of Topics in CRM.

Count(if(Owner='John Smith',Topic))

OR:

Count({$<[Owner]={"John Smith"}>} Topic)

i need to be able to add the Year or another criteria to that formula.

thank you for your help.

Re: Set Analysis Filter to filter 2 criteria

sunny_talwar — Mon, 04 Apr 2016 14:28:58 GMT

Try this:

Count({<Owner = {'John Smith'}, Year = {$(=Max(Year))}, FieldName = {'Condition'}>} Topic)