Button variables help

[#1]

Hi all,

I need your help !!.

I have a chart where I have to display the value Alphabatically and in Ascending and descending order.

I have 3 buttons,Sort by Alphabatically,sort ascending and sort descending.

And also I have a straight table below the bar chart which should show the values same as bar chart when you click those buttons.

Please help be with your ideas!!.

Thanks in advance.

[#2 · Accepted solution]

You can do it with variables. See attached.

[#3]

Thank you.That realley helped !!

I have another question.

Is there anyway we can do the sorting A-Z,Ascending and descending  by clicking one button instead of 3 different buttons??

[#4]

Yep, you just use one button to change the variable. Here you go.

[CELAMBARASAN]

Check the attached which is upgraded one based on Rebecca solution.

[#6]

Awesome !! Thank you !!

[#7]

Thank you very much..This is also one thing I was looking for !!