Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Dimension Style, Date, Sale$, Cost$. I am making a table with
I would like to filter out everything that has less than 35% GM%. What is the best way to do that in the app without heading into the Data load or even the SQL script.
EDIT: Here is the actual GM% expression which returns a decimal:
(1 -
(SUM({<[DateNum]={">=$(=$(vToday)-7)"}>}[Net Sales Cost])
/
SUM({<[DateNum]={">=$(=$(vToday)-7)"}>}[Net Sales Rtl])))
I guess the easiest way would be to modify sum(sales),sum(cost) and gm to return 0 if gm<35%, and use "hide zeroes" on the object properties.
Else, you would have to make GM a calculated dimension and use "include nulls", which is a bit of a headache.
Perhaps this way?
If(Num(<GM% Formula>, '#,#0%')>=Num(35/100, '#0%'), <GM% Formula>)
So this just nulls out that particular value in that particular column if it is less than 35% however I want the entire row to be removed.
I guess the easiest way would be to modify sum(sales),sum(cost) and gm to return 0 if gm<35%, and use "hide zeroes" on the object properties.
Else, you would have to make GM a calculated dimension and use "include nulls", which is a bit of a headache.
That is what I ended up doing. It isn't ideal because irl I have like 10 expressions so that is killing my performance but it isn't bad.
If you have many expressions maybe it's better to make a calculated dimension instead. That way you don't have to do future expression alterations, too.