Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this
Only({1<Company={'Company A'}>}RATING)
Try this,
Sum({1<Company = {"Company A"}>}Rating)
Regards,
Kaushik Solanki
Thanks! It worked