First Scene in Act
Report (see attached):
Part setup -
Sub-summary when sorted by 'Episode'
Sub-summary when sorted by 'Act'
Sub-summary when sorted by 'First scene in Act'
There are Sequences that go across multiple Acts. I need to split the total Budget or the Sequence up, so it only displays the costs relevant to the relevant Act.
See example attached (Report_example.pdf):
As you can see, Happy is in both Act 2, and 3 (total $11,259). I would like the costs to be split like this:
Act 2, 9 shots = $7,794.69
Act 3, 4 shots = $3,464.31
I'm at a total loss.