Alternate the Cell Background Color by Table Group
|Product Version||14.2 20.1118|
|Product||Progress® Telerik® Reporting|
What conditional formatting can I use to alternate the detail cell background color based on table groups?
For alternating detail rows in a table, I use conditional formatting based on the following Expression and set different colors for odd and even rows:
% is the remainder after the division operator. Then, I set the
Expression to depend on the group:
However, in the group, the row numbers increase within the group. That's why the color will alternate within the group rows, whereas my requirement is the rows of each group to have the same color and for this color to change between groups.
To handle the issue, use the following
RunningValue data function assures that only the values up to the current one get respected. The
CountDistinct aggregate function counts the distinct grouping values, in this case, up to the current one. This approach will leave
1 for the first group,
2 for the second, and so on. Hence, the
Expression will return
0 for the even groups within the table and
1 for the odd ones.