Apply Threshold on Bands and 2 dimensions and threshold should be on all the bands not based on first band

[amita1621]

Reinsurer name	Month	Section	Branch	Billed Status	Bands	Amt
A	Feb			Billed	0-90	1000050
A	Jan			Unbilled	91-180	50050
A	Jan			Billed	181-365	50050
A	Jan			Billed	>365	50050
B	Jan			Billed	0-90	50000
B	Jan			Unbilled	91-180	50000
B	Jan			Unbilled	181-365	50000
B	Jan			Unbilled	>365	50000
	Jan			Unbilled	0-90	1000000
	Jan			Unbilled	91-180	50000
	Feb			Billed	181-365	50050
	Feb			Billed	>365	50000
	Feb			Billed	0-90	50000
	Feb			Billed	91-180	50050
	Feb			Billed	181-365	50000
	Feb			Billed	>365	50000
	Feb			Unbilled	0-90	50000
	Feb			Unbilled	91-180	50050
	Feb			Unbilled	181-365	50000
	Feb			Unbilled	>365	50000

	Month	Feb
	Section	(All)
	Billed Status	Billed
	Sum of Amt		Bands
	Reinsurer name	Contact Name	0-90	91-180	181-365	>365	Grand Total
	A	AA	1000050				1000050
	(blank)	(blank)	50000	50050	100050	100000	300100
	Grand Total		1050050	50050	100050	100000	1300150

I want to replicate this format in qlikview.

The sample data and pivot are pasted above.

The filters are to be applied rest i want values from bands as '0-90' amt should be greater than 1lakh , '91-180' amt >50000 and '181-365' >50000 and '>365' > 50000

While i am trying the greater than applies to only '0-90 ' remaining band values  comes based on '0-90'

I want to apply a condition where i can apply conditions on all bands and also i need 2 dimensions also.

Please help?

	Month	Feb
	Section	(All)
	Billed Status	Billed
	Sum of Amt		Bands
	Reinsurer name	Contact Name	0-90	91-180	181-365	>365	Grand Total
	A	AA	1000050				1000050
	(blank)	(blank)	50000	50050	100050	100000	300100
	Grand Total		1050050	50050	100050	100000	1300150