Monday, December 10, 2012 11:58 PM
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
Tuesday, December 11, 2012 4:02 AM
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)
Here is the output
- Marked As Answer by KIWI DAVE Tuesday, December 11, 2012 4:39 AM
Tuesday, December 11, 2012 4:39 AM