Calculate column group with condition

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Calculate column group with condition

Calculate column group with condition

Rate Topic

Display Mode

Topic Options

Author

Message

waralees

Posted Monday, February 25, 2013 8:27 PM

Grasshopper

Group: General Forum Members
Last Login: Today @ 2:10 AM
Points: 20, Visits: 102

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.

Post #1423862

« Prev Topic | Next Topic »

Permissions