Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cheeeeeetah
Starting Member
2 Posts |
 Posted - 2007-08-11 : 04:34:35
|
| OrderStatus Month Total Day TotalStateName CityName sum(Fields!Order_Count_WP.Value) Total Total I Have Matrix (in Reporting Services) like This. infact I have tow Row Group(State,City) and Three Column Group (Order Status,Month,Day) all this group are Dimention in Analysis Services Cube.Order Status is a Dimention that Have This Values:1-Registered Orders 2- Vouchered Orders 3- OnDistributed Orders 4- Factored Orders. Fields!Order_Count_WP.Value is a Fact in Analysis Services that holds the Count Of Orders. imagin if I want to calculate the: Total Orders Rgistered in California(State),Sacramento(city) at month :january Day:01 sum(Fields!Order_Count_WP.Value) is Work good. But the problem is: if I want to calculate :the Percentage Of Total Orders Rgistered in California(State),Sacramento(city) at month :january Day:01 what must id do? Registerd Orders VoucheredOrders OnDistributed Orders Factored Orders January Day 01 California Sacramento % For Example I Want % Orders Registered in Sacramento in Day 01 ,January Of total Orders Registered in Month January or I Want % Orders Vouchered in Sacramento in Day 01 ,January Of total Orders Voucherd in Month January "I want something like this: format( sum(Fields!Order_Count_WP.Value,""matrix2_Day"")/ sum(Fields!Order_Count_WP.Value,""matrix2_Order_Status_Name""),""##0.##%""),"""")" |
|
|
|
|
|
Percentage of subtotal