Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a simple table with 2 (calculated) dimensions and 1 expression:
Dimensions:
aggr(if(count(YearM) = count(total YearM),IdZone4),IdZone4)
if(IdZone=IdZone4, Distr)
Expression:
Distr
So now i want to concat all the values separated by ", " of the 3th column, so one more time I need another aggr and i have to put the expression and dimensions of the table on it. I tried this with no luck:
=concat(
aggr(Distr,aggr(if(count(YearM) = count(total YearM),IdZone4),IdZone4),if(IdZone=IdZone4, Distr))
,', ')
Any idea?
Thanks,
David.
The main issue was achiveing that text to link that expression in a selection, so I splitet the process in 3 steps.
1) Select field A with that text expression surrounded with '(' and concatenated with pipes '|')
2) Select all possible values from field B
3) Clear field A (with this way we didn't see all that before-selected values)
Hi
Remove second dimension and try this expression:
=concat(if(IdZone=IdZone4, Distr, null()),', ')
The main issue was achiveing that text to link that expression in a selection, so I splitet the process in 3 steps.
1) Select field A with that text expression surrounded with '(' and concatenated with pipes '|')
2) Select all possible values from field B
3) Clear field A (with this way we didn't see all that before-selected values)