Forum Discussion
sum of cells
I would like to add the lines of Mechelen and Kempen. These lines repeat from January 2007 to December 2017. I have to keep a line with the result in each month of each year . ex: addition of meche...
Very easy using a pivot table...
Many thanks for your helpful answer.
How can I re-integrate these values in my Original table?
- I'm afraid I do not understand why you would want to do that. The pivot table displays a summary of your raw data, it is highly unusual to update raw data with summarised data from a pivot table.
these two companies merged in 2018. I need to be able to compare these data in dashboards. In 2018, the lines Mechelen and Kempen no longer exist but the single line Mechelen-Kempen, while our dashboards compare the data between the figures MK 2018 / M2017 + K 2017 or MK 2017/M2016+K2016.
Am I clear?I have to update the raw data with this data (see sheet6).