Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
Ani1991's avatar
Ani1991
Resolver III
6 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
6 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.