IF statement for straight table

[#1]

Hi,

I need to display a value in a straight table for one specific value. I have Date as dimension and Rating as expression in a table.

I only need to show Rating for Company A at all times ignoring any other selections that the user makes. So if the user selects Company B, the table should still show Company A Rating. I have this but it only works if Company A or nothing at all is selected:

if([Company] = 'Company A', RATING)

[manideep78 · Accepted solution]

Try this

Only({1<Company={'Company A'}>}RATING)

[kaushiknsolanki]

Try this,

Sum({1<Company = {"Company A"}>}Rating)

Regards,

Kaushik Solanki

[#4]

Thanks! It worked