Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is r

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is r

Post by answerhappygod »

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.Start of repeated scenario.You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.)Exhibit:Your company has 100 product subcategories and more than 10,000 products.End of repeated scenario.You have a PivotChart that uses Manufacturer as the axis and the sum of SalesAmount as the values.You need to ensure that only the top 10 manufacturers appear in the chart.What should you do?
Note This Quest 1
Note This Quest 1 (236.03 KiB) Viewed 67 times
A. Configure the Value Filters
B. Summarize the SaleAmount field by Max
C. Change the format of the SalesAmount field
D. Create a calculated column
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply