Hi everyone, I'm trying to create 3 sub rows (Beginning, Newly Added, and Ending) for each row (subline) in my table. Beginning of one year is the Ending of the previous year. Newly Reported is the amount recorded in that year. Ending is beginning + Newly Reported. I've attached a picture of the table in Excel that I want to recreate in Pyramid. 

I use 2 different formulas in Pyramid to calculate Newly Reported Counts and Newly Reported Combined Incurred for each year (with data imported from another file). So I don't know how to create a common "Newly Reported" subrow for each of my subline. Similarly with Beginning and Ending. I've attached a picture of what I currently have in Pyramid.

Thanks for your help!