Pivot Table dimension - columns of payment date amount by date

[Max1984]

I have the following pivot table (see attachment - "Tabella pivot.jpg") with two dimensions and an expression:

1) Dimensions: supplier and payment due date

2) Expression: 

SUM({<[% Master Calendar Date Num]={">=$(=$(vInizioPC))<=$(=$(vFinePC))"}, Anno=,Mese=,Giorno=>}[# Imponibile Pagamento])

I would like to have a pivot table with only one dimension (supplier) and the expression must give me the payment amounts for a single date in a column as the attached image (Requested pivot table).

[Max1984]

Great, but how can I do for the previous balance? for example if I have selected the current year (or current month) the balance must also consider the previous one.

is it possible to put the previous balance in the table as the first line or do I have to use a pivot table only with the expression?

thanks

[sunny_talwar]

I am not sure I follow... which previous balance are you talking about?

[Max1984]

In the figure, the balance with respect to the selected period is shown (see calendar object).

I would like the previous line to have the previous balance; the accumulation must also consider a possible previous balance.

[Max1984]

Are there no posts or documentation to resolve this request?