Alternate row color broken by grouping

[xeric]

Hello all.

I have a report with account number and some other fields which are all grouped. It then has a few ungrouped fields at the end, which are payment schedules for that account number. Each account can have 2 or 3 payment schedules, which creates "sub rows" within the row.

Is there a way to achieve alternating row colors that encompass these groupings? With row count + a mod formula, it doesn't work because it considers those "sub rows" of the ungrouped fields as new row numbers.

See below example I created in Excel to illustrate my question. The top example is what I am trying to achieve. The bottom example is what I get now, which is *not* what I want.

[dougp]

Create your expression:

ShadeMyList =

Code Select Expand

mod(rank(distinct [Account Number] asc, [Product] asc), 2)
Group by Product.
Group by Account Number.
Sort the Product group by Account Number and Product.
Sort the Account Number group by Account Number.
Sort the details as appropriate.
Create a conditional style based on ShadeMyList and apply it to all columns.

[xeric]

This is working perfectly, and it was easier than I thought. Thanks so much for your help dougp, I really appreciate it!