Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your first field is Company and your second field is Type:
In a straight table, define the Dimension as: =if(Type = 'Promoter',Company)
If your first field is Company and your second field is Type:
In a straight table, define the Dimension as: =if(Type = 'Promoter',Company)
Works a treat thank you very much!