How to filter out rows on straight table?

[mandilicious]

Hi All

Please help I would like to display only where Type = 'Current'  in this straight table.

Thanks

[sunny_talwar · Accepted solution]

May be use set analysis in your expression to show only Type = 'Current'

Sum({<Type = {'Current'}>} Measure)

[mandilicious]

Thanks Sunny perfect.

[mandilicious]

Hi Sunny

How can I filter in table box as well?

Thanks

[sunny_talwar]

To do this in table box, you will have to make a selection in Type field to select Current