hide dimensions due to possible fileds(?)

[Anonymous]

Hi,

I have a chart where i've combined 3 fields as a dimension

Department - employment - Gender

So in the chart the department will show 4 times if all combinations exsist (2 for gender, and 2 for employment)

But in the cases where department's only showing less than 4 times i don't want any of those deparment combinations to be shown at all. Is this possible?

Thanks in advance!

//A.

[#2]

Do you have a sample file with fake data?

[whiteline]

Coul you just provide your calculation dimension expression ?

[Anonymous]

=Department&'-'&employment&'-'&Gender

[whiteline]

As an example you can use something like this:

=aggr(if(aggr(nodistinct count(Department), Department) = 4, Department&'-'&employment&'-'&Gender), Department, employment, Gender)

It checks if there are four Department instances.

You could check employment and Gender instead, but it's a bit more complex.

[Anonymous]

Ah aggr, why didn't i think of that. Thanks!

But I only get a '-' in my dimension when trying this. so no dimension basically.

[whiteline]

I guess your data is more complex than I've used.

Do you have all fields in one table ?

Try this:

=aggr(if(aggr(nodistinct count(distinct employment & Gender), Department) = 4, Department & employment & Gender), Department, employment, Gender)