Please create a Pivot Table using the data below to show both the total $ amount and count of activity sorted by type Place the pivot table on a new worksheet (tab) named "January 2014"

How would I create this pivot table.

Date	Description	Type	Direction	Amount
2-Jan	Incoming Wire from Acct # 1123	Incoming Wires	Credit	$ 10,389
2-Jan	Incoming Wire from Acct # 1132	Incoming Wires	Credit	$ 10,174
2-Jan	Check #77	Checks	Debit	$ 17,353
2-Jan	Cash Deposit	Deposit	Credit	$ 65,000
2-Jan	Outgoing Wire - Paper Street Soap Company - Car Soap Division	Outgoing Wires	Debit	$ 8,478
3-Jan	Check #78	Checks	Debit	$ 3,959
3-Jan	Outgoing Wire - Little Tree Airfreshenor	Outgoing Wires	Debit	$ 40,344
3-Jan	Cash Withdrawal	Withdrawals	Debit	$ 60,000
6-Jan	Incoming ACH - Visa Settlement	Incoming ACH	Credit	$ 21,321
6-Jan	Check #79	Checks	Debit	$ 16,458
7-Jan	Incoming ACH - Mastercard Settlement	Incoming ACH	Credit	$ 24,858
7-Jan	Incoming ACH - American Express Settlement	Incoming ACH	Credit	$ 10,197
8-Jan	Outgoing Transfer - Acct # 46464	Outgoing Transfers	Debit	$ 20,715
8-Jan	Check #80	Checks	Debit	$ 6,319
8-Jan	Incoming Wire - Los Pollos Hermanos	Incoming Wires	Credit	$ 40,500
9-Jan	Incoming Transfer - Acct # 46464	Incoming Transfers	Credit	$ 42,415
10-Jan	Cash Withdrawal	Withdrawals	Debit	$ 40,700
10-Jan	Check #81	Checks	Debit	$ 1,967
10-Jan	Outgoing Wire - State of California Department of Taxation	Outgoing Wires	Debit	$ 20,656
10-Jan	Outgoing Transfer - Acct # 46464	Outgoing Transfers	Debit	$ 39,389
13-Jan	Check #82	Checks	Debit	$ 38,223
15-Jan	Incoming ACH - Visa Settlement	Incoming ACH	Credit	$ 14,676
15-Jan	Check #83	Checks	Debit	$ 32,293
15-Jan	Incoming ACH - Mastercard Settlement	Incoming ACH	Credit	$ 30,307
16-Jan	Incoming ACH - American Express Settlement	Incoming ACH	Credit	$ 3,176