How to make making a chart independent of a particular value in a list box

[Anonymous]

hi

I have a graph showing the trend of the tickets across month. This graph gets updated based on the filters applied for Application & Ticket Type. Ticket Type = IT alerts, Problems and Business Tickets

Now I dont want the graph to be updated based only if 'Problems' value is selected from the Ticket Type List box. Can you anybody please assist how this can be done in a set analysis?

[sunny_talwar]

So what should happen when Problems is selected? Everything should be visible?

[Anonymous]

if Problems is selected then the previous state should remain

[sunny_talwar]

Have not tested this, but may be this:

If(GetFieldSelections([Ticket Type]) = 'Problem', Sum({$1} Sales), Sum(Sales))

I am assuming that your expression is Sum(Sales), but you should be able to replace this with your original expression. The key is the use of $1 which means show previous selection.

[pipuindia99]

sum(<{Ticket Type = {' IT alerts', 'Problems' , 'Business Tickets'}>Sales)