Line Item Subsets and Summaries
I'm running into a curious situation where I'm trying to use the Summary of a module that includes a Line Item Subset downstream in another module. I'll walk through the situation below.
I built a single module to drive my line item subset, and I created a "top level" or summary item:
I created a line item subset that includes all the line items in the above module:
I'm using this line item subset to calculate errors for one of my input modules, so I pivoted my line item subset against the input module to generate the correct results. This shows my summary working as expected:
However, when I try to reference this line item in another module, it doesn't pick up the top level item using the "natural" summary, which is what I would have expected.
Note that it works the way I want when I do a SELECT on the top level item.
Is there something special I need to do in order to natrually use the Sum, or is this something that is just not possible with line item subsets?