Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
I am not sure I follow... which previous balance are you talking about?
In the figure, the balance with respect to the selected period is shown (see calendar object).
Are there no posts or documentation to resolve this request?