ignore current selection from Chart

[venkatg6759]

Hi Everyone,

I am using the below expression

sum({$<Rating={">7"}>}Sales) / sum ( Total <[Entity Name]> Sales)

Chart should not change when user selects rating from list box ,but it should change to all other listboxes.

I tried using 1 instead of $ but no use , even

sum({$<Rating={">7"},Rating=>}Sales) / sum ( Total <[Entity Name]> Sales) 

Any Ideas,

Thanks,

Venkata

[Gysbert_Wassenaar · Accepted solution]

Try sum({$<Rating={">7"}>}Sales) / sum ({<Rating=>} Total <[Entity Name]> Sales)

[Anonymous]

Try this:

sum({$<Rating={">7"}>}Sales) / sum ({<Rating = [1]::Rating>} Total <[Entity Name]> Sales)

Edit: The one above is less convoluted.  Use that.