How to make conditional format in Crosstabs at Crosstab node member and Crosstab intersection

Check list of all posts

As shown from attached screen shot below, different periods with different style are applied. Please download report specification for review if needed.


There are many ways of building such a report,  this report is simply built based on all different periods with clear union, as sometimes this might be the best way.


qCrosstab items


Report 



Three points are documented to share

1. Conditional style on crosstab node member

2. Calculation of growth

Single query to get growth

3. Conditional style on crosstab intersection

As growth uses percentage, which is different from all other numbers. Therefore, it is requested to make conditional format for data, or crosstab intersection.