PivotTable # and % column on same row

[jennymae4]

I'm connecting to Analysis Services; I need to represent the data in # and % columns and not sure how to accomplish this.


[TABLE="width: 662"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]System\Region\Location\Appointment Department[/TD]
[TD="colspan: 2"] 7/1/2018[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]#[/TD]
[TD]%[/TD]
[/TR]
[TR]
[TD]Total number of scheduled appointments[/TD]
[TD]100[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Total scheduled appts with linked referral[/TD]
[TD]50[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD] Total worked by the RAC[/TD]
[TD]30[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Authorized[/TD]
[TD]22[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Pending[/TD]
[TD]6[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Denied[/TD]
[TD]1[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Other[/TD]
[TD]1[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]First Status Update Median Days[/TD]
[TD]25[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Last Status Update Median Days[/TD]
[TD]2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]referrals updated on appointment date[/TD]
[TD]3[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD] Total worked by Others[/TD]
[TD]20[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Authorized[/TD]
[TD]13[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Pending[/TD]
[TD]2[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Denied[/TD]
[TD]5[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]Other[/TD]
[TD]0[/TD]
[TD]x%[/TD]
[/TR]
[TR]
[TD]First Status Update Median Days[/TD]
[TD]25[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Last Status Update Median Days[/TD]
[TD]2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]referrals updated on appointment date[/TD]
[TD]3[/TD]
[TD]x%[/TD]
[/TR]
</tbody>[/TABLE]