Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9 . Ravi also wants to list the paid and unpaid invoices for each month and then filter them by contract type. Create a PivotTable

image text in transcribed
image text in transcribed
9 . Ravi also wants to list the paid and unpaid invoices for each month and then filter them by contract type. Create a PivotTable that displays this information as follows: a. Use Power Pivot to create a PivotTable on a new worksheet, using Invoices by Month as the name of the worksheet. b. Display the SigningDate field values from the Query - Contract data source as row headings. C. Display the InvoicePaid field values from the Query - Invoice data source as column headings. d. Sum the InvoiceAmt field values from the Query - Invoice data source. e. Use the ContractType field from the Query - Contract data source as a filter. f. Group the signing dates to display them as years and months only

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: George H Bodnar, William S Hopwood

10th Edition

013609712X, 978-0136097129

More Books

Students also viewed these Accounting questions

Question

2. Find five metaphors for communication.

Answered: 1 week ago