how to have the year-to-date from the month fields?

[Anonymous]

Hello,

I would like to calculate the annual cumulation from the fields "month", since I do not have a fields year, how to proceed?

please ...

thank you for your reactions

[tresesco]

If you don't have a year field, can we safely assume that you have one year data only?

[Anonymous]

i don't have year field

[tresesco]

Could you post a sample data set and expected output ?

[Anonymous]

Here is the excel file I made a cross table in the script and I could have as fields: Data, month and sub indicator.

now I would like to have the year-to-date but using the month field that groups every month since I have no year fields.