Calculate a percentage

[dezmundw15]

I am new to Qlik Sense and I am trying to calculate an allocation percentage.  I am using Qlik Sense and I am utilizing a table.  I have the following column and rows

Provider	Facility	Patients Seen by Clinic	Patients Seen by %
Totals		200
Jenny	Clinic 1	50
Mary	Clinic 3	100
Suzie	Clinic 4	50

I would like to calculate the Patients Seen by Clinic/Provider or 50/200.  I am confused with the Aggr functions and the overall structure of the syntax

Sum(Provider)/ Sum(Patients Seen by Clinic should give me a % across the distribution of patients seen in the clinics...but I am getting nothing.  Can someone help me.

Thanks,

Desmond 

[sunny_talwar]

This did not work?

Count([SEEN BY PROVIDER])/Count(TOTAL [SEEN BY PROVIDER])

Would you be able to share a smaple?

[sunny_talwar]

Good, now please close this thread by marking correct and helpful responses.

Best,

Sunny

[sunny_talwar]

Please mark responses which truly helped you and not your 'Thank you' . I ask you to do this is do that future visitors can find this information useful in the future when they land on this page.