Percent difference in a subgroup

Question

Hi, yes i am back again, percentages on groups and subgroups

In my previous post i was able to deliver a total percentage (script after image), this is great, now i am struggling with this as a subtotal in each CurrentPriority,and then i need to give a break down of percentage for each category, i may have my table structure wrong.

So i have a total in the Patient Count Over Boundry, i want in the % Over Boundry by group of the Total WaitList Count..

Example: Cardiology 2-Semi Urgent = Total 7 and TotalWaitListCount= 56

Calculate 7/56*100

=Sum(Count(IIF(Fields!OverBound_Flag.Value="Yes",0,Nothing)))/(Sum(Count(Fields!WaitingListId.value)))

---

---

David

Answer 1

The following has fixed part of the challange

Show a percent diff for each Clinic Name

this is the script i have used in the % Over Boundry Column on (Current Priority Total Row)

=FormatPercent(Sum(Count(IIF(Fields!OverBound_Flag.Value="Yes",0,Nothing)))/Count(Fields!WaitingListId.Value,"Tablix1"))

Here is the output

---

David

Answer 2

Ok, I have it all done know...

What i did was added a Group Column (Below on (Current Priority) Group on(Clinic Name)

Expression remains the same:

=FormatPercent(Sum(Count(IIF(Fields!OverBound_Flag.Value="Yes",0,Nothing)))/Count(Fields!WaitingListId.Value,"Tablix1"))

My new output is:

---

David