Files to look at:
This example demonstrates how to show the products with top N sales by category.
The dashboard contains calculated fields with the following expressions:
| Field | Expression |
|---|---|
| ProductRankInCategory | aggr(w(RankDense(Sum([ProductSales]), 'desc'), PartitionBy([CategoryName]), OrderBy()), [CategoryName], [ProductName]) |
The grid shows the products with the ProductRankInCategory value that is more or equal to the parameter value (default value is 2).
Grid rows in the Top Products and OTHERS are sorted by the TopNProductsSortOrder calculated field for proper arrangement.
- Dashboard for WinForms - How to display best and worst monthly sales for each year
- Dashboard for WinForms - How to Calculate the Contribution of Quarterly Sales to Total Yearly Sales
- Dashboard for WinForms - How to evaluate a customer acquisition using the quarter/year of their first purchase
- Dashboard for WinForms - How to divide customers' count by the number of orders they made
- Dashboard for WinForms - How to calculate Highest Product Sales by Year
- Dashboard for WinForms - How to display sales by years in comparison with the previous year's sales
- Dashboard for WinForms - How to Display Product Sales that are Greater than $20k
- Dashboard for WinForms - How to Display Products with Sales Greater than Average Sales per Category