you can create subtotal using Pivot table. Have a look into Pivot table chart properties --> presentation layer --> Show partial sums. You can enable the partial sum for any level of dimensions.
Regarding the formula, have a look into the below one:
sum(if (InMonth ([Order Date], SetDateYear (Today(), max (total Year ([Order Date]), 1)), 2), REV))
welcome in the community.
As first question I would like to know if I can create sub total by field, and if yes how do that?
Yes, you can easily insert sub totals in pivot tables in Chart Properties --> Presentation tab --> select the field for which you wish to see subtotal and check flag Show Partial Sum.
as clarification for the 2 question in the original post formula I have translated the field ANNO iso YEAR from the picture enclosed.
While what I would to achieve in the second case is the incremental REV, year over year. I cannot use the above/below formulas because I have different values in the 3rd column and are mixed. I need some formula which read the ANNO, MESE and 3° column in each row and take the REV referred to ANNO-1
thanks a lot for your help