10. Reduce the clutter in the PivotTable by modifying it as follows: a. Change the report layout to show the PivotTable in Outline Form. b. Group the Project Start values by Months. 11. Hwan occasionally would like to focus on the project data according to the star Add a Timeline Slicer as follows to the Projects by State worksheet: a. Insert a Timeline Slicer based on the Project Start field. b. Move and resize the Timeline Slicer so it covers the range A34:F40. c. Adjust the Timeline Slicer to view all months.
Added by John C.
Close
Step 1
Step 1: Open your Excel workbook and navigate to the worksheet containing the PivotTable you want to modify. Show more…
Show all steps
Your feedback will help us improve your experience
Shelayah Robinson and 87 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Akash M.
Tableau Assignment Attached Files: Problem_Data_CH11.xlsx (59.364 MB) Open Tableau desktop. Connect to the Excel workbook which is attached in this assignment. Drag the four sheets to the canvas and connect them: Sales connects to Stores by StoreID Channels by ChannelID Products by ProductID Go to Sheet1 Create a vertical bar chart that shows the sum of Sales Amount by Channel Name. Change the title of the sheet to "Channel Sales 2020." Rename the worksheet to "Channel Sales Bar." Insert a new worksheet. Make sure the Show Me options are displayed on the right. Select Channel Name (dimension) and Sales Amount (measure) (holding down the CTRL key). Review the potential chart options. Choose the pie chart. Change the view (ribbon bar) from Standard to Entire View so the pie chart appears larger and in the center of the sheet. Click on the (SUM) Sales Amount pill next to the pie slice icon under the Marks area. Select Quick Table Calculation > Percent of Total so the pie chart shows the percent of total sales for each slice. Drag Channel Name to the label mark to label each slice with the channel name. Change the title to "Channel Sales Percentages." Rename the worksheet to "Channel Sales Pie." Insert a new worksheet. Drag Date (dimension) to the Columns shelf. Drag Sales Amount to the Rows shelf. Click on the plus in the Year(Date) pill and then click on the plus in the Quarter(Date) pill (the Columns shelf should now show three pills: Year(Date), Quarter(Date), and Month(Date)). Remove the Year(Date) and Quarter(Date) pills to leave only the Month(Date) pill on the Columns shelf. The result should be a line chart showing the sum of sales by month. Drag Channel Name to Filters. Select all channel names. Click on the Channel Name pill down arrow and select Show Filter. The filter now appears on the right. Click on the down arrow in the filter and change the filter to a single value list. Hide the label field at the top and change the title to "Sales by Month." Change the worksheet name to "Sales Trend." Insert a new dashboard. Add your three worksheets to the dashboard. Use the Sales by Month graph as a filter (click the funnel on the top right of that graph and toggle until it is set as the filter or use the down arrow below the funnel and select the use as filter option). Select a month and verify that all the graphs change with your selection. Save your work. Save Tableau as a Tableau workbook named Tableau_11.
Sri K.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD