Hi there,
I would like to create a table like:
Table | Issue1 | Issue2 | Issue3 |
---|
Food | 500 | 250 | 12 |
Clothing | 34 | 666 | 23 |
Car | 27 | 6 | 1 |
These issues should be calculated from a table that contains the following:
Table | Low Fat | Too big size |
---|
Food | UNDEFINED (x500) | |
Clothing | | UNDEFINED (x34) |
Car | | |
So basically it needs to add up all the 'UNDEFINED' per row per field. Any idea?