The application consists of 40 tables, which come from two production planning systems.
The upper pivot table consists of 7 tables. At this point the informations are complete.
The lower table sums up the columns, ignoring some of the values.
I can not change anything about the structure of the data, which I get from the IT department. It should be possible to sum up the values anyway or not?