Hello. I'm doing a local custom version of Revenue by Source and Appeal (ap_camp_appeal_expense). In it individual source codes are subtotaled by source groups. The person I'm building this for would like there to be additional subtotals of certain source numbers (but not others) that have the same source group. So for example, in the source group 12 'development' (which already subtotals), source numbers 2, 5, and 7 should also subtotal, but not 1, 3, 6, etc.
I don't see a good way to do this. Has anyone else run into something similar?
The only I see you doing this is by have some sort on other grouping. This is either going to involve hard coding sources and have a new sub group column....yuk or a custom system table to determine new sub groups. ie. source_no, source_group, source_sub_group. Either way neither is ideal since it involves another thing to maintain. Are you sure there is no other common things to group on?
Travis
That does remind me, there are a number of other data points on Sources, "Media Type", etc. We certainly don't use them all.