Need help with conditional statement in pivot table

[#1]

Hi

I have the following data:

locations	ticket_number	ticket_age
irvine	101	1
irvine	102	2
utah	103	5
utah	104	1

I'm trying to create a pivot table like this:

locations	ticket_age <2	ticket_age > 4
Irvine	1	0
Utah	1	1

My dimension is locations, however, I can't seem to do a conditional expression correctly to get me the counts I needed.

I tried If(ticket_age < 2, count(ticket_number)) which doesn't work.

Any suggestions?

[#2 · Accepted solution]

put the count on the outside:

count(If(ticket_age < 2, ticket_number) )

[#3]

That's what I needed.  Thanks!