What is the difference for such a simple crosstab? First of all, this crosstab is discontinuous crosstab. It is a little different from normal crosstab, all cells are NOT shared the same default measure Revenue. Please note that same conditional style are defined for both crosstabs
While the query structures are same,
However, the query item definitions from both queries are different
Max:
Query 1: maximum (CurrentMeasure within set [Sales (analysis)].[Products].[Products].[Product line])
Query 2: maximum ([Sales (analysis)].[Sales].[Revenue] within set [Sales (analysis)].[Products].[Products].[Product line])
Avg
Query 1 and Query 2 are same:
average([Sales (analysis)].[Sales].[Revenue] within set [Sales (analysis)].[Products].[Products].[Product line])
Variance
Query 1 and Query 2 are same:
([Max]-[Avg])/[Avg]
Conclusion: when making conditional style for discontinuous crosstabs, we should NOT use default measure in any query items. We should directly use measure expression. Please note that not using default measure may impair report performance.
No comments:
Post a Comment