Dimension based on selection

[livetolearn]

Hi All, 

I just wanted to know how do i  change the dimension of a table or bar chart , 

Example : I have a bar chart  with dimesion "Region"  and expression as Sum(Sales) . 

Now I want to have a list box as variable in (0 and 1) if I select 1 then the table should show Dimesnion as "Country" 

and If 0 then the table chart should show "Region ".

Is this possible to make the table or bar chart change the dimesions according to the selection from the list box ?

Thanks

[MayilVahanan]

Hi @livetolearn 

Try like below

=If(vUserInput = 1, Country, Region)

[livetolearn]

@MayilVahanan  

I created the variable vUserInput and in definition I assigned one , 

And in the dimension  i mention your above mentioned expression , 

But the thing is how do i make the selection 1 or now selection in a list box ? 

And also the header of the dimesion should change  if its Region or Country ? 

I am stuck on this 

[MayilVahanan · Accepted solution]

Hi @livetolearn 

Create a listbox using inline or create dropdown list box.

Load * inline

[

UserInput

1

0

];

and make it "Always one selected value".

In dim expression,

=If(UserInput = 1, Country, Region)

--

Label: =If(UserInput = 1, 'Country', 'Region')

Hope it helps