Question: Continue from Problem 8. Select HOME > PivotTable to create a PivotTable report from your integrated Power Pivot tables. a. Use the ChannelName from the

Continue from Problem 8. Select HOME > PivotTable to create a PivotTable report from your integrated Power Pivot tables.
a. Use the ChannelName from the DimChannel table as the first rows field. Use the calculated column 1 field from the FactSales table as the second rows field. Use the SalesAmount field from the FactSales table as the values field. Change the number format to currency, if necessary; change the name of the calculated column 1 in the PivotTable report to Month; and change the values column name from Sum of SaleAmount to Total Monthly Sales. Change the report layout to tabular form.
b. Insert slicers for both ChannelName and Month.
c. Which channel had the highest total sales in January?
d. Add a column pivot chart. Change the title to Total Monthly Sales. Use the slicers to show the comparison among channels for sales in January.

Step by Step Solution

★★★★★

3.34 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

From the Power Pivot screen select the Home tab and the PivotTable icon At the Pivot Table works... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

1598_6062c74d32928_665709.pdf

180 KBs PDF File

1598_6062c74d32928_665709.docx

120 KBs Word File

Students Have Also Explored These Related Accounting Information Systems Questions!

Tech Tool: Spreadsheet Software Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts This exercise is a continuation of the sustainability decision model used in the...

Open a blank Excel workbook and bring in the FactSales data from the ContosoSales Access database as follows. Select DATA > Get External Data > From Access. Browse to the ContosoSales Access...

Tech Tool: Spreadsheet Software, Database Software Software Videos: Spreadsheet ODBC, Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts EspressoCoffee has asked for your assistance...

Please explain each step im having a hard time understanding where I am going wrong. \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\...

Please Answer all the question. Jay Stoller is a sales analyst at PCC Sport, a chain of sporting goods stores in the western United States. Jay is working on a sales report that will detail customer...

Sorry there are out of order. I am having a lot of trouble with this assignment. All information is provided. Please provide exact steps and equations to get to answers. Thank you. File Home Create...

i have steps a-c done. how do i use power pivot to insert a pivot table with multiple tables? Access database. Import the data from the Access database and insert a PivotTable as follows: a. b. C....

8. Move to a new worksheet. Be sure that you have activated the PowerPivot add-in. Select Power Pivot > Manage to open the Power Pivot screen. Move to the Power Pivot for Excel screen. Select Home >...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

43 AaBbCcDc AaBbc AaBbCc) AaBbCcDd AaBbCcDd Emphasis Heading 1 Heading 2 11 Normal 1 Normal ... Paragraph Styles Instructions Points Possible exercise begins on page 343 of your text. Start Excel....

Show that we can prove that P(n, k) is true for all pairs of positive integers n and k if we show a) P(1, 1) is true and P(n, k) [P(n + 1, k) P(n, k + 1)] is true for all positive integers n and k....

Mack Rogers needs to learn quickly about Section 1244 stock. How should Mack approach his research?

provide me all the files with all the functions implemented with proper code. file: fscMalloc.h #ifndef FSCMALLOC _ H #define FSCMALLOC _ H #ifdef _ _ cplusplus extern " C " { #endif #include...

=+g. How would your answer to (f) change if wage fell instead?

Which methodology of systems development requires one phase be completed before the next phase begins? a. Agile model b. Waterfall model c. Scrum model d. Sequential model

If an IT project costs $150,000 and returns net cash flows of $100,000 per year, what is the accounting rate of return? a. 33 percent b. 50 percent c. 67 percent d. 75 percent e. None of these.

Which of the following are not examples of operating costs for an IT investment? a. Costs of routine hardware replacements over time b. Cost of contract for help desk support c. Costs of disposal of...

Suppose that the index model for stocks A and B is estimated from excess returns with the following results: R A = 3% + 0.90 R M + e A R B = 2.0% + 1.20 R M + e B M = 26%; R -square A = 0.21; R...

please write the code in python. UESTION 1- Please write a code that searches for a node in a tree structure. If it finds the node given the code must eturn all the parent nodes starting from the...

"Starting with last week's introduction to valuation and continuing with this week's topic on discounted cash flow valuation, we learned that one of the key variables in determining the value of any...