label expression based on dimension

[amien]

how can i set the label of an expression.. based on the value of above dimension (i'm using a pivot)

Thanks!

[amien]

or if i have something like columnno in the pivot then i can this in label with IF's

columnno is not working btw 🙂

[d_pranskus]

Actually I believe that value of the label cannot be based on dimension value, because it is calculated before the chart is being rendered.

Nevertheless here is some workaround.

Cheers

Darius

[amien]

Ok, sorry for the late reply .:)

but i don't get it .. i know PICK, but you use that in your expression. i have one fixed expression SUM(value) and i need a different label for each one .. do i need to use PICK in the Label Expression?

[CELAMBARASAN]

Hi,

     Can you tell me based on what condition the dimension gets changed?.

Celambarasan

[amien]

my pivot has:

2 dimensions: 1 on the left and  1 on top

3 expressions: the label name of the last expression should be dynamic

the name is based on the second dimension (the one that is on top).

so, it can be dimension name. Or perhaps on the position of expression 3 : the first two columns needs to be a certain name, and de rest another name.