I have a reports with the following group structure:
Chain - Group 1
Rep - Group 2
Due Date - Group 3
A rep can belong to more than one chain. I need to know how many chains the rep belonged to at a particular due date to and then make that total it available to a formula in the due date group.
For example, Rep A services Chain 1, Chain 2 and Chain 3 on due date 7/1. I need to get the value 3 into a formula in the due date group so I can divide a total amount by that number to share costs across all chains the rep serviced in that due date.