I have a pivot table (image), as dimensions I have YEAR, MONTH, company name, pdr. As an Expression I have Sum (CONSUMO_SMC)
I would need by selecting the years 2021 and 2020 that this table would show me the Sum (CONSUMO_SMC) from the current month to the current month -12 is it possible?
.. and i add: I would also like to have in the last column, after the Grand total, the total number of MONTHS that have a value> 0