Sunday, December 22, 2013

How to make conditional style for a discontinuous crosstab

Please see sample below, where conditional style is NOT working for the first crosstab, but working for second crosstab. see report specification ( version 10.2) for review


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