Hide Measure based on Dimension Values in Pivot table in Qlik sense

[KishorePandurangan]

Hi,

I have fields called Product and its measures related to the product.

In below table, Product and Country (Country A and Country B) are dimensions. Country dimension is being dragged top next to measure.

And Measure is a expression, which is pulled as a column next to product.

1. sum(value) as SUM

2. AVG(value) as AVG

Product A only has measure SUM not AVG, similarly Product B only has AVG not SUM. 

Product	Measure	Country A	Country B
A	sum	10	10
A	Avg	0	0
B	sum	0	0
B	Avg	5	5

I want Measure AVG to be hidden for Product A, and Measure SUM to be hidden for Product B.

Output:

Product	Measure	Country A	Country B
A	sum	10	10
B	Avg	5	5

Thanks.