Track remaining AR balance over a period of time

[#1]

I’d like to take the current AR bucket, for a population of loans, and track the remaining AR amount by month. I attempted to do this by showing an AR date and a measurement date equal to AR Date, but the data isn’t displaying as expected.  For example, I’d like the pivot table below to show the current AR balance by Measurement Date (vertically) and the remaining balance each month by AR Date (horizontally).  I've attached my data and the QV file in which I'm trying to create the chart shown below. 

Current

ARDate

Jan-16

Feb-16

Mar-16

Apr-16

May-16

Jun-16

Jul-16

Aug-16

Sep-16

Oct-16

Nov-16

Dec-16

Measurement Date

Jan-16

Feb-16

Mar-16

Apr-16

May-16

[ravikumar_iyana]

Hi,

At time of loading excel into Qlikview Application use to Cross Table after words try this

[#3]

My data is formatted as shown below.  Would a cross table be necessary to aggregate ARAmt by ARDate and Measurement Date with this data format?

LoanNum	ARAmt	PaymentDueDate	ARDate
13110970	$               1,097.08	1/15/2017	1/31/2017
13110970	$               1,026.52	2/15/2017	2/28/2017
13110970	$                  878.67	4/15/2017	3/31/2017
13110970	$                  889.80	4/15/2017	4/30/2017
13110970	$                  820.58	5/15/2017	5/31/2017
13110970	$                  667.48	7/15/2017	6/30/2017