Suppress rows of a Pivot Table based on dimensions values

[Anonymous]

Hi, Qlik newbie here and working on my first qlikview report

I have a pivot table with 2 dimensions

1. Product Type
2. Country of Origin

Expression is a Sum of Returns

How can I suppress the entire row based on 2 conditions

1. Country = USA, CHINA AND sum is > 0

or

2. Sum > 0 for all Countries

Example Pivot Table:

Product	Total	USA	CHINA	GERMANY
Wrench	50	10	40	-
Spanner	2	-	-	2
Hammer	100	10	80	10

The outcome based on the above should only show the Wrench and the Hammer Rows

Any feedback is appreciated, thanks

[sunny_talwar]

Why is Spanner not shown? It does meet the second condition of Sum > 0? or this is an and condition? If it is, then try this

May be this

Sum({<Product = {"=Sum({<Country = {'USA', 'CHINA'}>}Returns) > 0 and Sum(Returns) > 0"}>}Returns)