in Technology by

How Can You Display the Top Five and Bottom Five Sales in the Same View?

1 Answer

0 votes
by

Follow these steps:

  1. Drag the Customer Name field to Rows shelf and Profit field to Columns shelf to get the visualization.
  2. Create a set by right-clicking on the Customer Name field. Choose to create an option and click on Set.
  3. Provide the name ‘Top Customers’ to the set. Configure the set by clicking on Top tab, selecting By field, and filling the values as Top, 5, Profit, and Sum. 
  4. Similarly, create a second set called ‘Bottom Customers’ and fill the By Field values as Bottom, 5, Profit, and Sum. 
  5. Select these two sets and right-click on it. Use the option Create Combined Set. Name it ‘Top and Bottom Customers’ and include all members of both sets. Pull the Top and Bottom Customers onto Filters.

The top five and bottom five are displayed:

Related questions

0 votes
    How to display the top five and the last five sales in the same view?...
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
    To exert control, you mentioned intervening top to bottom. Is that with AAD at the top and SharePoint sites at the bottom?...
asked Mar 10, 2021 in Technology by JackTerrance
0 votes
    C. Choose the right option: 1. The bottom margins and top of a document can be changed by using the . a ... indent c. Increase indent Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    I've found the following CSS code that I pasted in the child theme's css stylesheet, but it doesn ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 16, 2022 in Education by JackTerrance
0 votes
    I've found the following CSS code that I pasted in the child theme's css stylesheet, but it doesn ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 13, 2022 in Education by JackTerrance
0 votes
    Find the Top Product Subcategories by Sales Within Each Delivery Method. Which Subcategory Is Ranked #2 for First-class Ship Mode?...
asked Mar 30, 2021 in Technology by JackTerrance
0 votes
    Suppose, without using a line/bar chart, I want to design a view to show the region-wise profit and sales. How should I go about doing it? Explain...
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
    Design a view in a map such that if a user selects any state, the profit and sales in the cities under that state would show up....
asked Oct 30, 2020 in Technology by JackTerrance
0 votes
    A top-to-bottom relationship among the items in a database is established by a (a) Hierarchical schema ... in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    I've managed to read some values into a table view and display them in the Master View of a ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 19, 2022 in Education by JackTerrance
0 votes
    I have set up Vue so that I have a top level AppLayout component which just includes a Navigation Menu ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 20, 2022 in Education by JackTerrance
0 votes
    You can create your own style by clicking on the __________ button located at the bottom of style pane. * a.style ... d.none of these Select the correct answer from above options...
asked Dec 15, 2021 in Education by JackTerrance
0 votes
    Write code in HTML to divide the browser window into 3 horizontal sections and display college name in the top most frame. Select the correct answer from above options...
asked Dec 22, 2021 in Education by JackTerrance
0 votes
    A company wants to find the best sales representative. Which of the following techniques do you recommend to find it? A. Account Insights B. Lead Scoring C. Opportunity Insights...
asked Nov 1, 2022 in Education by JackTerrance
0 votes
    I'm in need of some help in getting a View to layout data it is accessing from a database ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jan 13, 2022 in Education by JackTerrance
...