View original (French)

Pivot table

ValDEVAL -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   -

Hello everyone.

I would like to know please, how from pivot tables in Excel, one can calculate the difference between December of the previous year (2023) and January of the following or current year (2024)?
In case this cannot be done with Excel, is there a tool that can automatically perform this calculation based on data contained in a database?

Best regards,

1 réponse

Réponse 1 / 1
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 

Hello.

Yes, there is a tool in the Excel database: subtraction!

Pivottables are not at all meant for that...

Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)
0