[Ticket Number]asTicketNumberKey, // key filed to link SLA table
if ([Ticket Type]='Incident',1,0) as[CounterIncident],
if ([Ticket Type]='Catalog Task',1,0) as[CounterTask],
I want to declare a filter using the field [Ticket Type] after the above three lines. As I have renamed it to [Counterincident] and [CounterTask] based on the stages, how do I use the field [Ticket Type] ??