Suppress zeros in chart with more than one expression

[dapostolopoylos]

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?

[dapostolopoylos · Accepted solution]

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".

😀