Issue about variable searching

[Anonymous]

When i select a value of the variable "Cluster_F1" (=1, in this case) it takes all the raw (not only "1", but it selects the dimension "POD").
Is there a way to select only a value of the variable "Cluster_F1" instead the dimension "POD"?

[dplr-rn]

Not completly clear what you mean.
I am assuming you want variable Cluster_F1 to be calculated once globally and not consider the dimension. Is that right?
if so define the variable with = at start like
=If(if(TIPO_..............

[Anonymous]

Yes, i don't want to consider the dimension when i select the variable ClusterF1, which is already defined as variable as follows:
SET v_Cluster1=IF($(v_Tot_cons_perd)<5000,1,
IF($(v_Tot_cons_perd)<20000,2,
IF($(v_Tot_cons_perd)<500000,3,4
)));

[dplr-rn]

I meant define it like below with the = which means it will be calculated only once and not change when you add it into tables/charts

[Anonymous]

Ok, i tried but it worked like before in the selection (it selects only the dimension and not the entire cluster of observations with the same value of Cluster1), moreover it returns the same value for the observations of the variable Cluster1.