## Calculate column group with condition

 Author Message waralees SSC-Addicted Group: General Forum Members Points: 474 Visits: 128 I have data---------------------------------------- Date | region | Type | Value----------------------------------------01/01/2013 | Asia | B | 20.0001/01/2013 | Asia | S | 15.0001/01/2013 | Europe| B | 82.0001/01/2013 | Europe| S | 26.0001/01/2013 | Africa | S | 15.0002/01/2013 | Asia | B | 10.0002/01/2013 | Asia | S | 30.0002/01/2013 | Europe| B | 45.0002/01/2013 | Europe| S | 55.0002/01/2013 | Africa | S | 7.00I user matrix to build report -------------------------------------------------------------------------------------------------Date | Asia | Europe | Africa | |----------------------------------------------------------------------------------| | B | S | total | B | S | total | S | Total |--------------------------------------------------------------------------------------------------01/01/2013 | 20.00 | 15.00 | B-S | 82.00 | 26.00 | B-S | 15.00| B-S | 02/01/2013 | 10.00 | 30.00 | B-S | 45.00 | 55.00 | B-S | 7.00 | B-S | My Question 1. How can I fix that all type (buy/Sell) have to show in all region column(not show B in Africa)?2. How can I calculate net value for each region/ each day??Many Thanks in advance.