Qlik Sense - hide row in pivot table

[Anonymous]

Hi,

I have created the following Qlik Sense pivot table:

Country	State	City	Amount
USA			8 000
	Alabama		4 500
		Montgomery	1 000
		Birmingham	2 000
		Mobile	1 000
		Hoover	500
	Quebec		1 000
			1 000
	Ontario		2 500
			2 500

I want to hide rows with empty City. Totals and subtotals shoud be left as is .

Any idea how to solve this?

Regards,

R

[Chanty4u]

HI

try some thing like this

if(sum(Amount)>0,City)