Pivot Table Filter on Column

[zhbuyiqlik]

I would like to do the following in Qlik Sense.  I am wondering if there is a way to do it using a pivot table.   Alternatively, I can produce a straight table, and do the same operation.   But I'd prefer to use pivot table to do it.  Thanks!

I created a pivot table using like table 1

Table 1

Region	A	B	C
North	1000	1000	1000
East	2000	50
West		200	2000
South	1000

Now I want to filter on product C so that only show rows where sales for C is greater than 0.  I want the product selection to be user defined.    i.e. If the user select product A, then we would filter on A using the same condition.  

Table 2

Region	A	B	C
North	1000	1000	1000
West		200	2000

[zhbuyiqlik]

If I understood you correctly, my original data is "organised" with one product column and a value column (sales).  What I am showing in the original post is a pivot table I created in Qlik Sense based on the original data.   The structure of the original data is like the following:

Client ID	Region	Product	Sales
1	North	A	1000
2	North	B	500
3	East	C	100
4	East	B	1000
5	Sourth	A	500
6	Sourth	C	200
7	West	A	300

[zhbuyiqlik]

Not exact number as shown in the original post, but this shows the structure.

Client ID	Region	Product	Sales
1	North	A	1000
2	North	B	500
3	East	C	100
4	East	B	1000
5	South	A	500
6	South	C	200
7	West	A	300

[OmarBenSalem]

no need for the crosstable load so; just do as I've told u at first and tell me what happens

[Thiago_Justen_]

May be this:

Sum({<Product={"=Sum(Sales)>0"},Region={"$(=GetFieldSelections(Region))"}>}Sales)

Here we have to filters that will be done:

Region and Product

[Thiago_Justen_]

Here is the result:

[OmarBenSalem]

Sum({<Region={'North','West'}>}Sales)

result: