如何限制表中显示的行数? [英] How to limit the number of rows displayed in a table?
问题描述
我有一个数据源,一个数据集和一个数据立方体.数据多维数据集具有一个组和一个具有计数功能的摘要字段.
I have a Data Source, a Data Set and a Data Cube. The data cube has a group and a summary field with a count function.
在报告中,我有一个按该摘要字段排序的表.该表有很多行(〜1000),但我只想显示前5行.
In the report I have a table sorted by that summary field. This table has a lot of rows (~1000) but I only want to show the first 5.
如何限制显示的行数?
推荐答案
表和交叉表都具有前N个运算符,可根据需要过滤行.在您的情况下,这是一个基于数据多维数据集的交叉表:
Both tables and cross-tables have a top N operator allowing to filter rows as your requirement. In your case this is a cross-table based on a datacube:
选择交叉表->过滤器选项卡->添加->选择度量->运算符前N个"(或下N个",具体取决于交叉表的排序方向)
请注意,如果这种方法是基于数据库的,则其效率要比数据集查询中的分组和过滤效率低得多.
Please note this approach is much less efficient than grouping and filtering in a dataset query, if it is based on a database.
这篇关于如何限制表中显示的行数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!