expression for % for straight table

[Ashutosh11]

I want a calculation of consumed % for below table in qlik :

ENGG.	JOB SHEET	CONSUMED PART QTY	Consumed %
AB	1	2	%(total sum of consumed part qty/total sum of jobsheet)
ABB	1	1	%(total sum of consumed part qty/total sum of jobsheet)
ABC	1	4	%(total sum of consumed part qty/total sum of jobsheet)
ABCD	1	5	%(total sum of consumed part qty/total sum of jobsheet)
DFFH	1	1	%(total sum of consumed part qty/total sum of jobsheet)
DHSYC	1	2	%(total sum of consumed part qty/total sum of jobsheet)
SXHS	1	1	%(total sum of consumed part qty/total sum of jobsheet)
Total	7	16	%(total sum of consumed part qty/total sum of jobsheet)

[agigliotti · Accepted solution]

Hi @Ashutosh11 ,

Maybe this:

sum(CONSUMED PART QTY)/sum( TOTAL <JOB SHEET> CONSUMED PART QTY )

I hope it can helps.

Best Regards