Reason for this post is I’m curious if I’m doing this the best way possible. See attached image.
You’ll see I have an “Org” in the first control source in the detail section, and then moving horizontally to the right, you’ll see I have a domain aggregate to sum the amount for the corresponding org and month. Also, in the second row in the detail section, I have a running sum over all to get the total for the respective months and quarters. These controls are hidden. In the page footer, I reference the total in the detail section to get the grand total for each month and quarter. This is what I question:
In addition to my above questions/concerns, if you see anything that can be done better, please let me know.