Total & Remaining Amount based off specific date

[MalcolmCICWF]

Could anyone lend me some help/advice on laying out my data in the below format and example? I am not sure on the best way to go about this via Dimensions and Expressions within a Straight or Pivot table...

I have a couple cyclic groups that my end users would like to sort on. They need a totals column as seen by "Remaining ERCs as of (date)", and then they need ERC Month/Year laid out horizontally to show just how much ErcAmount remains in each.

If I can achieve this, I also need to find a way I can select or enter which ERC Month/Year the sum of the Totals begin In my example it is 1/1/2016, I would like to be able to change that to any date... Thoughts?

[sunny_talwar]

I am not sure why you deleted you last post, but since I have it already prepared, I am going to share my sample anyway

See if this helps now (Driven by the Inputbox)