Hello everyone,
I am building a cash management file and I managed to get it well untill I want to finalize my pivot-table report.
The thing I am trying to obtain is exactly describe here : https://www.youtube.com/watch?v=q5M20UwxY1Q but for a confusing reason I don't obtain the same result..
I have daily cash operations on several account for several entities and I want a "balance sheet" made from the initial balance + the operations, grouped by month & a variance month-on-month.
I manage to obtain that by creating a "sum, running total in" in my pivot-table. The wierd thing is when I add again the field amount and choose "difference from, date, previous" I have a calculation that doesn't make any sense to me.
I searched a bit, and another wierd thing is that the "variance" or difference is ok if I just had my operations amount field but I then have a first variance column with the full amount of january which is quite misleading.
I'm a bit surprised as I am sure I used to produce that kind of simple pivot table calculation right in the past...
example (with difference from previous) :
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
example (with added column without running total in :
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Target :
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
If someone could help.
Have a nice day
I am building a cash management file and I managed to get it well untill I want to finalize my pivot-table report.
The thing I am trying to obtain is exactly describe here : https://www.youtube.com/watch?v=q5M20UwxY1Q but for a confusing reason I don't obtain the same result..
I have daily cash operations on several account for several entities and I want a "balance sheet" made from the initial balance + the operations, grouped by month & a variance month-on-month.
I manage to obtain that by creating a "sum, running total in" in my pivot-table. The wierd thing is when I add again the field amount and choose "difference from, date, previous" I have a calculation that doesn't make any sense to me.
I searched a bit, and another wierd thing is that the "variance" or difference is ok if I just had my operations amount field but I then have a first variance column with the full amount of january which is quite misleading.
I'm a bit surprised as I am sure I used to produce that kind of simple pivot table calculation right in the past...
example (with difference from previous) :
| janv | févr | mars | ||||
| k € | var | k € | var | k € | var | |
| St2 | (161,2) | (88,2) | 234,3 | (150,2) | (135,1) | |
| CHARGES EXTERNES | (21,0) | (29,5) | 12,6 | (51,0) | (13,1) | |
| HONORAIRES | (8,4) | (28,1) | (11,2) | (41,6) | 6,1 | |
| IMPOTS ET TAXES | (32,8) | (32,8) | 32,8 | (32,8) | - | |
| INT | - | 90,4 | 90,4 | 83,6 | (97,2) | |
| XX | (29,9) | - | 59,7 | - | (29,9) | |
| SALAIRES ET CHARGES | (69,1) | (88,2) | 50,0 | (108,3) | (1,1) |
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
example (with added column without running total in :
<colgroup><col><col span="6"></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Target :
| janv | févr | mars | ||||
| k € | var | k € | var | k € | var | |
| St2 | (161,2) | (88,2) | 73,1 | (150,2) | (62,0) | |
| CHARGES EXTERNES | (21,0) | (29,5) | (8,5) | (51,0) | (21,5) | |
| HONORAIRES | (8,4) | (28,1) | (19,7) | (41,6) | (13,5) | |
| IMPOTS ET TAXES | (32,8) | (32,8) | - | (32,8) | - | |
| INT | - | 90,4 | 90,4 | 83,6 | (6,8) | |
| XX | (29,9) | - | 29,9 | - | - | |
| SALAIRES ET CHARGES | (69,1) | (88,2) | (19,1) | (108,3) | (20,2) |
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
If someone could help.
Have a nice day
