Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, experts.
What i am trying to achieve is the following:
I have a straight table with numerous dimensions and more than one expressions. What i want to do is that i want to suppress the rows that display at least one zero values.
For example if my chart is the following
Dim1 | Dim2 | Dim3 | Expr1 | Expr2 |
George | Employee | Male | 10 | 20 |
John | Administrator | Male | 5 | 0 |
Valery | Developer | Female | 0 | 10 |
Rick | Manager | Male | 50 | 7 |
Susan | Manager | Female | 0 | 0 |
Mary | Secretary | Female | 10 | 10 |
what i want to show on my app it he following
Dim1 | Dim2 | Dim3 | Expr1 | Expr2 |
George | Employee | Male | 10 | 20 |
Rick | Manager | Male | 50 | 7 |
Mary | Secretary | Female | 10 | 10 |
How can we do that?
It's funny how the solution comes to you right after you post a question on the forum 😁
My working solution is this:
I replaced the first dimension with the Calculated one of that type:
=If(Not IsNull(Aggr(Sum(Expr1),Dim1)) and Not IsNull(Aggr(Sum(Expr2),Dim1)),
Dim1)
and then i ticked the "Suppress when value is Null".
😀
It's funny how the solution comes to you right after you post a question on the forum 😁
My working solution is this:
I replaced the first dimension with the Calculated one of that type:
=If(Not IsNull(Aggr(Sum(Expr1),Dim1)) and Not IsNull(Aggr(Sum(Expr2),Dim1)),
Dim1)
and then i ticked the "Suppress when value is Null".
😀