Displaying Records Matching a Criteria

[stuwannop]

Hi Everyone

I think this is fairly straightforward but I can't figure it out.

All I want to do is display a table but only containing records that match a certain criteria. A table box or even a straight table (chart) would be fine. I want to display a lit of "Detractors" and then a seperate list of "Promotors". Can someone show me the bets.easiest way fo doing this without the user having to filter? So if my data looks like this:

     Company A          Detractor

     Company B          Detractor

     Company C          Promoter

     Company D           Detractor

Then my "Promotor" table would only contain Company C.

Thanks for your help.

Stu

[m_woolf · Accepted solution]

If your first field is Company and your second field is Type:

In a straight table, define the Dimension as: =if(Type = 'Promoter',Company)

[stuwannop]

Works a treat thank you very much!