Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmak
Starting Member
41 Posts |
 Posted - 2006-04-24 : 11:19:03
|
| I have a matrix report with a percentage calculated field on the "column" column grouping. The dataset consists of several fields, Year of Invoice Date, Month of Invoice Date, Product Name, Category, Quantity Sold, Unit Price and Subtotal (Quantity Sold x Unit Price). There are two levels of the "row" column grouping, Category and Product Name. Two levels of the "column" column grouping are "All" and "By month and year of the invoice date" and the rest of the fields assigned to the "detail" grouping. Both of the "row" and "column" column groupings have drilldown enabled. The percentage calculation is based on the "subtotal" of the "row" and "column" grouping ie it is dynamically computed depends on the state of the grouping. I need to create a report for the "Top 30 best selling "Category" and I can sort the Category field with the Subtotal (DESC) to show the highest subtotal as the first record. However I dont know how to limit the first 30 recrds to be shown on the report ot can it be done? |
|
|
pmak
Starting Member
41 Posts |
Posted - 2006-04-24 : 11:25:10
|
| Correction to my post. Only the "Subtotal" field assigned to the "detail" grouping and the rest of the fields, Quantity Sold and Unit Price to "Row" column grouping with NO drilldown. Thanks. |
 |
|
|
|
|
|
How to limit the number of records showing?