using variable to render straight table (expression)

[dreweezy]

I have a straight table with many columns that are pertaining to a sales person within a company. I have 5 buttons, related to that sales person, that I hope will render my table based on the user selecting a button.

if($(vTableFilter)= 1, sum({<SALES_PERSON= {"Michael Johnson"}>} SALES),
if($(vTableFilter)= 2, sum({<SALES_PERSON= {"Jordan Peele"}>} SALES),
if($(vTableFilter)= 3, sum({<SALES_PERSON= {"Kobe Bryant"}>} SALES),
if($(vTableFilter)= 4, sum({<SALES_PERSON= {"Lupe Fiasco"}>} SALES),
if($(vTableFilter)= 5, sum({<SALES_PERSON= {"Magic Johnson"}>} SALES)
)
)
)
)
)

My table doesn't seem to be rendering at all. I did a quick check by adding the SALES_PERSON column within the table and I can see that once I click a sales person (button) it still shows the other 4 individuals. Thoughts?

[Anil_Babu_Samineni]

Sugar is the definition of variable

[marcus_sommer]

Why so complicated and not just using SALES_PERSON as a listbox?

- Marcus

[dreweezy]

End users want something more interactive on a dashboard with buttons since there are only a few sales person. I was able to figure it out - for some reason once I deselected "null values" on the dimensions everything started to work. Thanks.