Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Buttons

Hi Everyone ,      so basically (as shown in the picture below)  I want to have the shown buttons to switch between two values (GP= Gross profit) and (OP= Operating profit)    so the axis will c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

thanks for your answer, the thing is i do not have a column under the name (VS)  

 

So, I did not quite get the syntax of the measure below 

 

VS_GP_OP = SWITCH(SELECTEDVALUE(VS[VS]),"vs GP",[SUMGP],"vs OP",[SUMOP]

 

please clarify more would be great :)  

Ani1991's avatar
Ani1991
Icon for Resolver III rankResolver III
7 years ago

Hi Anonymous 

You need to create a connectionless table using the Enter Data option like below. It is a seperate new table.

image.pngAnd then you would create a measure like below in your main dataset

VS_GP_OP = SWITCH(SELECTEDVALUE(VS[VS]),"vs GP",[SUMGP],"vs OP",[SUMOP]

which says, if the user has selected vs GP under the Chiclet slicer then display the measure [SUMGP] and if the selectedvalue is vs OP then show the measure [SUMOP].

 

Let me know for any further concerns.

 

Thanks,

Ani

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Ani,

     

    i am not clear about how to enter vs GP & vs OP in the values inside the table , these are values (gp & op)  under a column named KPI in one of the tables in my data set. if there is another solution or clarification please lemme know :) 

     

     

    thanks for ur support. 

     

    omaima.