The image below shows an example of a table that contains the orders of different customers per month. In the second table I want to create an overview for monthly analysis. Therefore I need the sums of the orders by month in the second table.
Since it is not possible to have different formulas for each cell I can’t figure out how to do this.
Does anybody know a way how to solve this?
What I want to achieve is this: