View original (French)

Pivot table

ValDEVAL -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor 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 answer

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     

    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