Qlikview Pivot

[#1]

I made a pivot to show two surgeons' supplies utilization. I want to show the number of cases in each row as a percent of the total cases. The formula I used will work if one surgeon is selected but If I select more than one it returns blank/zero. Does anyone know how to write a formula that will populate the "% of Total Vol" column? The Spreadsheet is below.

Thanks

Surgeon	Surgeon 1				Surgeon 2
MPC Description	Cases	MPC Units Per Case	Cost Per MPC	%of Total Vol	Cases	MPC Units Per Case	Cost Per MPC	% of Total Vol
TISSUE STRATTICEFO	1	1	100	-	-	-	-	-
TISSUE STRATTICE ADE	2	1	34,765	-	2	1	235	-
TISSUE STRAARS TTICE	1	1	786	-	-	-	-	-
ALLODERMISM  RTMTHICK	2	1	987	-	1	1	6,753	-
GRAFTER ALLODERM	2	1	5,674	-	1	1	4,563	-
ALLODERM RTYTM	4	1	234	-	3	1	9,865	-
GRAFT ALLOD423ERM	2	2	765	-	-	-	-	-
MESH WOUND VRMATRIX	-	-	-	-	1	2	8,797	-
STEM FEM STANDARD	1	2	8,765	-	-	-	-	-
Total	15				8

[ramoncova06]

count(total cases) will give you all the total cases, though if you select a filter the total will only apply to the possible values of the filter

count(total <Surgeon>Cases) , this is similar to the one above with the difference of grouping the total by Surgeon

[#3]

Thank you. I will do some work with the formula and let you know

[#4]

This maybe of help:

Count or Count distinct?

Link : Count or Count distinct?

Im not on my work computer but hopefully its in the right direction for you.