Set Analysis Filter to filter 2 criteria

[Anonymous]

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.

[sunny_talwar]

Try this:

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