February 25, 2013 at 8:27 pm
I have data
----------------------------------------
Date | region | Type | Value
----------------------------------------
01/01/2013 | Asia | B | 20.00
01/01/2013 | Asia | S | 15.00
01/01/2013 | Europe| B | 82.00
01/01/2013 | Europe| S | 26.00
01/01/2013 | Africa | S | 15.00
02/01/2013 | Asia | B | 10.00
02/01/2013 | Asia | S | 30.00
02/01/2013 | Europe| B | 45.00
02/01/2013 | Europe| S | 55.00
02/01/2013 | Africa | S | 7.00
I 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.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply