Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have the following situation:
company | sales | order | diff | value |
companyA | 13 | 11 | 5 | 7 |
companyB | 0 | 0 | 1 | 6 |
companyC | 20 | 4 | 5 | 4 |
Now I want to show only the dimensions, where the sales column and the order column are not zero. In this case companyB should not be visible.
For example:
sales is sum(X+Y+Z)
order is sum(Z+Y+Y)
dimension is company.name
The following doesn't work:
if(sum(X+Y+Z)<>0 and sum(Z+Y+Y)<>0, company.name)
Can anyone help me?
Thanks
How can I write a script, which filters the dimension?
Hi, you can do this based on dimensions or in expressions:
On dimensions, uncheck the option to show null values and use this calculated dimension: Aggr(if(sum(X+Y+Z)<>0 and sum(Z+Y+Y)<>0, company.name), company.name)
On expressions, on add-ons uncheck the option to show zero values and add the check in each of the other expressions (diff and value in the sample): if(sum(X+Y+Z)<>0 and sum(Z+Y+Y)<>0, [ColumnExpression])