Please create a Pivot Table using the data below to show both the total $ amount
ID: 3844179 • Letter: P
Question
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,176Explanation / Answer
1. Select the data cells or tables (including headers )for the data you want to use
2. From "insert" tab click on "pivot table" command
3. The "create pivot table " dialogue box will appear choose your settings and click on OK
4. Blank pivot table and the field list of the worksheet will be appear in new worksheet/existing worksheet as u selected settings in step 3
5. Once pivot table is created u need to decide which fields to add. The each field u selected will be the column head of the source file. In pivot table field list check the box for each field u want to add
6.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.