Please Help Me, Select Single Dimension

[Anonymous]

Hi Everyone,

I've question from this example table

Agent_Type	Agent_Name
1	QW
2	AS
1	ER
3	DF
1	RT

How to view only Agent_Type = 1, in dimension for calculate some expresion...

Thanks for your help

[sunny_talwar]

Couple of ways.

1) Calculated Dimension: If(Agent_Type = 1, Agent_Type) and then select 'Suppress When Value Is Null' on the Dimensions tab.

2) Set Analysis within the Expression:  {<Agent_Type = {1}>}