|
<< Click to Display Table of Contents >> How to Make TOP N Sorting |
  
|
|
<< Click to Display Table of Contents >> How to Make TOP N Sorting |
|
TOP N ranking means that the largest or smallest N data are selected from the sorted list.
1.Add Component
From the right component pane, drag the bar chart component to the editing area.
2.Bind Data
From the left data list, drag the dimension "Product" to the Row axis and drag the measure "Sales" to the Column axis to generate the bar chart.
3.Set Advanced Sort
1)In the binding area, open the "Product" operation menu and select [More Sort] -> [Advanced Sort].
2)In the advanced sorting dialog box, select [Descending], [Aggregation Column]; select the column as "Sales", and the aggregation method as "Sum", that is, the system will rank based on the total sales of the product.
3)In the TOP N area, enter the number 5, that is, after ranking, the system will only show the five products with the highest sales. Click [OK]. The following TOP 5 chart is finally obtained.
