Calculate Column

[SCM]

BASED ON THIS TABLE I WANT TO FIND UNIT USAGE BY  TYPE AND AMOUNT

BILL ACC	TYPE	UNIT USAGE	UNIT PRICE	MIN AMOUNT	MAX AMOUNT
1900	HOUSE HOLD	0	7.00	7.00	7.00
1901	HOUSE HOLD	1-35	0.80	0.80	28.00
1902	HOUSE HOLD	>35	2.00	2.00	as per usage amount
1904	INDUSTRIES	0	30.00	30.00	30.00
1905	INDUSTRIES	1-35	2.80	2.80	98.00
1906	INDUSTRIES	>35	3.30	3.30	as per usage amount

THIS RED COLOR  RESULT I WANT HAVE FROM THE QLIK SENSE

BILL ACC	TPYE	AMOUNT	0	1-35	>35	TOTAL USAGE
1900	HOUSE HOLD	7.00	-	-	-	-
1901	HOUSE HOLD	28.00	-	35.00	-	35.00
1902	HOUSE HOLD	90.00	-	35.00	31.00	66.00
1904	INDUSTRIES	30.00	-	-	-	-
1905	INDUSTRIES	98.00	-	35.00	-	35.00
1906	INDUSTRIES	150.00	-	35.00	36.97	71.97

PLEASE TEACH ME HOW TO THE SCRIPT FUNCTION ABOVE CALCULATION 

[lironbaram]

hi 

it's really not clear how do you calculate the bottom table according to the first table 

can you explain your calculations logic 

otherwise i don't see how you can get help  

[SCM]

please refer to the attachment,

I hope this will give you a clear picture.

[jonathandienst]

Unfortunately, it does not. I suggest you explain your requirement in words rather than expecting people to unpack and understand your Excel sheet.

[Channa]

try to use crosstable load

use 2 arguments

[SCM]

lol i also try to explain it but it is **bleep** hard , ok let me try it something i will come back to you guys.