This content has been marked as final. Show 1 reply
I have Product, Market dimensions and a table of values.
Market is divided into Markets and Market Areas.
What I want to do is to sum the data on Market Areas and return 0 each time at least one market is 0 or missing.
Market Product Demand
UK Prod1 10
France Prod1 5
Italy Prod1 11
UK Prod2 5
1) the sum per market area should result in this:
EU27 0 (since Germany is missing)
2) but the sum per market area per product should result in this:
MarketArea Product Demand
EU Prod1 10+5+11
EU Prod2 0 (instead of 5 since Italy and France are missing)
EU27 Prod1 10 + 11
EU 27 Prod2 0 (instead of 5 since Italy and Germany are missing)
How can I do this?