10 Replies Latest reply: Apr 29, 2016 12:54 PM by Sunny Talwar RSS

    Total & Remaining Amount based off specific date

    Jeremy Schmitt

      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?

       

      Capture.JPG