Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a straight table showing 3 dimensions and 10 Expressions..
Now, I'd like to show only records depending on given condition.
In following example, I'd like to show only records where I have "Volumes PY" <> 0 AND "Price gap" <>0
Do I need to set these conditions in each Expression?
thanks
Andrea
Hi,
you could multiply every Expression with "if("Volumes PY" <> 0 AND "Price gap" <>0, 1, 0)" and use "Supress Zero-Values" at the presentation Tab. Or you create a flag in the data model using "if("Volumes PY" <> 0 AND "Price gap" <>0, 1, 0) as flagShowRecord" and multiply every Expression with the flag.
Regards
Sebastian Lettner
Hi,
I would add a flag in your data model.
Something like the below
IF([Volumes PY] <> 0 AND [Price gap] <>0,
1,
0
) AS FLAG,
Then in the set analysis on each expression Add {<Flag ={1}>}
i.e.
SUM({<Flag ={1}>}[Net Sales])
Hope this helps
Mark
Yep Marks solution should work for you.
Hi Mark
thanks for your reply...
I cannot easily (and in a short time...) add a flag to data model and requirement changed to Previous Month instead of Previous Year.. ok that should not be a problem..
directly in the chart
I have to try to solve it directly in the chart.. if possible
I thought there was an option like Filter where [condition satisfied]..
thanks
Hi,
you can put the condition in the dimensions also as,
if("Volumes PY" <> 0 AND "Price gap" <>0, Plant).
Are you using Plant as your dimension?
then what aalsaif1 suggested should work for you. use this as your dimension
If("Volumes PY" <> 0 and "Price gap" <>0, Plant) and then check 'Suppress When Value Is Null' option
I'm using Plant, Customer and Material as dimensions...
It should still work. Just replace Plant with a calculated dimension -> If("Volumes PY" <> 0 and "Price gap" <>0, Plant) and check 'Suppress When Value Is Null' option
Hi Andrea,
I think Sunny's approach is probably going to be your best bet if time is a factor.
If it doesn't work as above you could look at adding a calculated dimension for each, Plant, Customer and Material.
Mark