I'm connecting to Analysis Services; I need to represent the data in # and % columns and not sure how to accomplish this.
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
| System\Region\Location\Appointment Department | 7/1/2018 | |
| # | % | |
| Total number of scheduled appointments | 100 | x% |
| Total scheduled appts with linked referral | 50 | x% |
| Total worked by the RAC | 30 | x% |
| Authorized | 22 | x% |
| Pending | 6 | x% |
| Denied | 1 | x% |
| Other | 1 | x% |
| First Status Update Median Days | 25 | |
| Last Status Update Median Days | 2 | |
| referrals updated on appointment date | 3 | x% |
| Total worked by Others | 20 | x% |
| Authorized | 13 | x% |
| Pending | 2 | x% |
| Denied | 5 | x% |
| Other | 0 | x% |
| First Status Update Median Days | 25 | |
| Last Status Update Median Days | 2 | |
| referrals updated on appointment date | 3 | x% |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
