create filter on Straight Table

[Anonymous]

Hi All,

I have 4 types of Competency in data but what i want is to see only there and want to restrict one(i.e _Total).

Please find attached .qvw

Thanks

Manish Madan

[m_woolf · Accepted solution]

For the Competency dimension, enter:

     =if(commpetncy<>'_Total',commpetncy)

Then check Supress when value is null

[Anonymous]

Thanks Michael

[Anonymous]

A good practice is not to load the "total" at all.  Just to filter it out in script by using this:

WHERE Competency <> '_Total'