Announcements
cancel
Showing results for
Did you mean:
Partner - Contributor II

## Pivot table with annual financial information

Hello everyone,

I need to create a simple financial table with the annual resume, something like this:

 Month Type Income (€) Outcome (€) Transport (€) Begin Year 500 jan Material 100 500+300-100=700 Sales 300 fev Food 100 700-600=500 mar 500 apr 500 may 500 jun 500 jul 500 aug 500 sep 500 nov 500 dec Sales 500 500+500-30-50=920 Material 50 Food 30 End Year 920

My problem is in the development of the last colum

I have a variable to calculate the values of Income / Outcome and I tried to create the transport column by:

=\$(vIncome) - \$(vOutcome) - Sum({1<Year={\$(vMaxYear)}, MonthNum = {1} >} [Value]) (To get my value at the begin of year - January)

but I am getting transport values only when I have income/outcome values :

 Month Type Income Outcome Transport Begin Year 500 jan Material 100 500+300-100=700 Sales 300 fev Food 100 700-600=500 mar - apr - may - jun - jul - aug - sep - nov - dec Sales 500 500+500-30-50=920 Material 50 Food 30 End Year 920

Is there any solution to "propagate" the same value of the begin of year (500) by all months to get the correct results?

And there is any solution to add the rows 'Begin Year' / 'End Year' to the table?

best regards

Labels (3)