Hiding options in a table

[#1]

Hi,

I have a chart which shows results based on different statuses in a table. There is a total of four statuses: Good, bad, extra, and free. I would now like to hide the "Extra" and "Bad" results from the table so that a user cannot select them. My idea of how to do this would be to input either a condition on the table itself were it only shows "Good" and "Free", or input a trigger on the sheet that does the same, but I dont really know how to do this. Any ideas?

Cheers,

[Nicole-Smith]

If you want to hide the "Extra" and "Bad" results from the table, add the following set analysis to whatever your expression is:

{<Status={'Good','Free'}>}

So your final expression will look something like:

sum({<Status={'Good','Free'}>} Value)

[#3]

Sorry, I dont want to hide the results (per say) I want to hide the option of having them there to begin with. The idea is that the user is to click in the table and that way filter out what he sees on screen, but I want to limit these options. I cannot just select not to select the data, however, since that would skew up the rest of the results.

[#4]

Try something like this in the Add calculated Dimension

if(Status <>'Extra' or Status <>'Bad, Status) and the check 'Suppress when values are null

[#5]

sorry, but this is a list box, i dont have the "suppress when null" option...

[MK_QSL]

In the list box expression.... type below..

=if(Status <> 'bad' and Status <> 'extra' , Status)

[#7 · Accepted solution]

Hi,

PFA. Hope it helps!

[#8]

worked perfectly! thanks!