我需要对包含聚合数据的矩阵列应用交互式排序。
该报告统计了在不同地方销售的产品:
Product A Product B Product C
---------------------------------------------------------------
Country 1 5 10 4
City A 3 0 3
City B 2 10 1
---------------------------------------------------------------
Country 2 10 5 5
City C 2 4 2
City D 8 1 3
在对"Product A“进行降序排序后,应按"Product A”在国家/地区的销售额以及按城市的销售额对表行进行排序:
Product A Product B Product C
---------------------------------------------------------------
Country 2 10 5 5
City D 8 1 3
City C 2 4 2
---------------------------------------------------------------
Country 1 5 10 4
City A 3 0 3
City B 2 10 1
矩阵方案如下所示:
| [Product]
[Country] | [City] | [Count(Product)]
发布于 2011-09-01 15:54:22
矩阵中不支持交互式排序。
解决方法可能如下所示:
使用以下值创建排序依据参数:
Label Value
Country ASC, City ASC 1
Country DESC, City ASC 2
Country ASC, City DESC 3
Country DESC, City DESC 4
然后在国家/地区中创建两个排序表达式:
=Iif(Parameters!SortBy.Value = 1 OR Parameters!SortBy.Value = 3,Fields!country.Value,"")
ASCENDING sort
=Iif(Parameters!SortBy.Value = 2 OR Parameters!SortBy.Value = 4,Fields!country.Value,"")
DESCENDING sort
对city执行相同的操作:
=Iif(Parameters!SortBy.Value = 1 OR Parameters!SortBy.Value = 2,Fields!city.Value,"")
ASCENDING sort
=Iif(Parameters!SortBy.Value = 3 OR Parameters!SortBy.Value = 4,Fields!city.Value,"")
DESCENDING sort
https://stackoverflow.com/questions/7246043
复制相似问题