Question: 1 0 Use Power Pivot to import the Transactions table from the Access database e 1 0 c 1 PledgeDollars.accdb into a PivotTable. Place the
Use Power Pivot to import the Transactions table from the Access database ecPledgeDollars.accdb into a PivotTable. Place the PivotTable on a new worksheet named Pledge Dollars. Add the Date field to the Filters area, add OperatorID to the Rows area, and add PledgeAmount to the Values area. Save the workbook.
Create a relationship between the OperatorID in the Transactions table and the OperatorID in the Volunteer Information worksheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
