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.
(https://i.imgur.com/8OdkJxn.png)
Create your expression:
ShadeMyList =
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.
This is working perfectly, and it was easier than I thought. Thanks so much for your help dougp, I really appreciate it!