Hi, what I'm trying to do seems simple to me, but I just can't seem to wrap my head round it.
I have a number of dimensions, related to a trade, eg client, client type, currency etc. I have a number of expressions which are all of the format
SUM(metric)*$(vEx)
where vEx is a variable holding the exchange rate.
What I want to do is, have a dropdown or input box, where a user puts in a value (or selects a value) storing it into a variable (vThreshold) and then the chart updates to only show rows where the
SUM([$ TV])*$(vEx) >= $(vThreshold)
If I do something like IF(SUM(metric)*$(vEx) >= $(vThreshold), SUM(metric)*$(vEx)) then it gives me nulls for the rows that dont meet the requirement. I need some sort of set analysis so that it doesn't show those rows at all, but I just cant work out any kind of way of doing that?
