Pricing Report

 Hi,

I have created a report which pulls all appointments booked by employees per day. What I want to do is create a pricing report which would show the dollar amount of an employee based on the price per appointment. Is that possible through reports ? or should I just use the Reports Analysis for Excel tool and create a macro with countif functions ?

EG:-

Employee	XYZ	EF	DFFSD	FSSF	Total
a	50	60	100	60	270
b	100	110	110	50	370
c	60	50	110	110	330
XYZ	50
EF	100
DFFSD	60
FSSF	110

I apologise if this question sounds silly.