You're almost there - but you'll need a couple more small steps to get this to work.
I'm assuming that you've got the Sales line defined as a Detail template?
And that all the records have a Card Type above them?
And that one Card Type only has one Sales line?
Thjen you can trap the Card Type as an Append, Cleared By.the Detail, and the last Sales line can be filtered out as the Card Type field will be null.
Hope this helps,
Thanks, Olly. I already had Card Type as an append, so I tried the Cleared by: Detail and filtered out the blank Card type as you suggested. It worked!
I had never noticed that Cleared by feature. Smooth!
P.S. I’m replying to your response through my email, but went first to the Datawatch Community via the link below and could not find a way to REPLY!
There was no REPLY button I could find….any suggestions on where to look???