Qlik Sense Pivot with percentages

[#1]

Hi all

I have the following table with the rawdata:

NR	Project	Task	KST	KOA	ID	Description	Status	Assignee	Risk Level	Deadline
					1	API Design 2	Closed	John	Medium	18.09.2016
					2	API Development 2	Behind	Martha	Low	31.08.2016
					3	API Testing 1	Work in Progress	Jill	High	14.07.2016

and I need to produce the following pivot:
    

Task Status/Priority		High	Medium	Low	Total	% of Total
Closed		0	1	0	1	25%
Work in Progress		1	1	0	2	50%
Behind		0	0	1	1	25%
Not Started		0	0	0	0	0%
Total		1	2	1	4	100%
		25%	50%	25%	100%	6.25

Any Ideas how to achieve a pivot with percentages?

Thanx and best regards

[sunny_talwar]

Would you be able to share a sample?

[#3]

Hi Sunny T

I have the following excel with the rawdata and the mockup dashboard as it should look like.

Best regards