Roll Up Sub-Dimensions

Hello, I have an issue that is difficult to describe so I provide an example subset below:

The data looks something like this:

INDEX

(for reference)

2017

N

In this scenario, I need to be able to calculate SUMS for each [Primary Sale] (as indicated by the value Y) together with the corresponding non-primary sales and return one record per [Primary Sale] with the same values for the fields as the [Primary Sale] and a total.

For example, Bob only has one primary sale, but the total of all non-primary sales corresponding to that sale total to 50. Therefore, Bob would have one record with the [Sale ID] of B3 and a total of 50.Alice has three separate primary sales with no corresponding sales so there would be three records for her, each with the corresponding values of only her primary sales.

Alice, on the other hand, has three separate primary sales with no corresponding nested sales so there would be three records for her, each with the corresponding values of only her primary sales.

The result should look something like this:

INDEX

(for reference)

What calculation could I use to accomplish this type of nested aggregation?

I tried IF and CASE statements and even considered LOD expressions but nothing clicked.

Thanks for your input!

Sincerely,

-Anthony