Adding Column After Matrix Total
<P>Greetings,</P>
<P>I am new to reporting services and am struggling with trying to add a column to the end of matrix report that has totals. You can see a jpg of the report at http://www.catertots.com/matrix.jpg What I need to do is repeat the school code that is in the first column into another column that follows the total. </P>
<P>Any help would be much appreciated.</P>
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Adding Grand Total To A Column Group In A Matrix. Please Help!
Hello Guys, I am working on a matrix report which has several row groups and 1 column group. After execution, the column group wil end up with several columns containg numeric counts. I would like to have the grand total for each "column group" column as a last row on this report. For row groups you can just right click "Subtotal", but that is not possible for column group. Could someone please help me to find a clever way of accomplishing this, please. Thank you so much for your help!
View Replies !
View Related
How Do I Add A Percentage Column After The Total On A Matrix?
Hi. I am looking to create a Matrix-based Report in SQL Server 2005 Reporting Services. I have my query, and a dynamic number of both rows and columns. I have Totals on the "bottom" and "right". What I'd like to do is add a Percentage column to the right of the right-based Totals column. So the columns would read Col1, Col2, .., ColN, Total, Percentage. Is this possible??? Thanks.
View Replies !
View Related
How To Calculate An Total Avg Column In Matrix?
Hi!! I'm really new in Reporting Services. I've to calculate a Total column in Matrix with a specific formula. Is it possible ? Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 TOTAL Row 1 val val val val val SUM(val)/5 Row 2 val val val val SUM(val)/4 Row 3 val val val val val val SUM(val)/6 Row 4 val val val SUM(val)/3 Row 5 val val val val val val SUM(val)/6 Row 6 val val val val val val SUM(val)/6 Row 7 val val val val val val SUM(val)/6 Row 8 val val val val val val SUM(val)/6 Note that I've all the datas of the Matrix (Col / Row / val) except the value of the, here names, TOTAL columns that I've to calculate in the Report. Thanks a lot. Alex
View Replies !
View Related
Matrix Report Total Column
Hi Everyone, I am designing a report in SQL Server 2005 Report Designer that uses a Matrix table. The matrix table is grouped by month. How can I add a Year-To-Date total column on the report? This is driving me nuts...I cannot figure this out. Thank You -Sam
View Replies !
View Related
Adding A Total Column
I have been working on a website in asp.net1.1 in vb.net2003. I am using a sql2000 server. I am attempting to add a column to my datagrid that will add the total number of wins and output the number in that colum. With some help, I have been able to write the code. However, I am not sure where to put it. Is it a sql function I need to call from my code to add to the win column? Thanks for your help.
View Replies !
View Related
Adding A Total Column
This is a very simple select but I would like to add a final column that adds the QOH, QOB, QOO and Quantity. How can I accomplish this? Thanks SELECT DISTINCT zcus_MM_Medsurg_Used.stock_no, zcus_MM_Medsurg_QOH_Only.qty_on_hand AS QOH, zcus_MM_Medsurg_Used.QOB, zcus_MM_Medsurg_Used.QOO, zcus_MM_Medsurg_Used.QUANTITY FROM zcus_MM_Medsurg_QOH_Only INNER JOIN zcus_MM_Medsurg_Used ON zcus_MM_Medsurg_QOH_Only.stock_no = zcus_MM_Medsurg_Used.stock_no
View Replies !
View Related
Matrix - Hiding A Specific Row In Column Total
Hi, I have created a matrix with multiple rows in the main data cell and a subtotal at the end of the row. The first row in my matrix main cell is just a count of records, whereas the 2nd row is a % of the value in the 1st row compared to the total of that row. I have 5 columns in the matrix as below (only first row is shown plus the total row. Ignore any rounding issues): Status A B C D E Total 02/01/2007 No. 9 32 3 13 0 57 % Total 15.00% 56.00% 5.00% 24.00% 0.00% 100.00% Total No. 77 143 25 72 2 319 % Total 135.00% 350.00% 48.00% 250.00% 2.00% 556.00% I have a total column at the end. I want to hide the %Total row within the total row as it does not make sense in this context. Anyone know how to achieve this? Thanks
View Replies !
View Related
Grand Total Column In Matrix Report
Hi, Hi All, I am having some trouble getting a Grand Total column at the end of my matrix report (not row at the bottom), such as you get by default in an Excel pivot table. I have managed so far to add another column that sums up all values across the data range for a particular product code. My intention was to hide all but the last (I did something similar on rows). However you cannot use an expression on the width property for columns, so this will not work. My report is very standard: Year Month (grouped by year) Product code | Description [qty] I want a column that displays the total qty across all dates for each row. Surely this is possible? Any suggestions would be appreciated! Thanks.
View Replies !
View Related
Hide Calculated Column In Matrix Report And Show Only In Total
Hi All, I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using InScope, as it creates *Blank column. Please go thru details below. Year Month01 02 03 Total Salary Salary Salary Salary Cumulative (Calc) Employee01 20 5 25 25 Employee02 10 10 20 45 ..... Total How can i achieve this?. Any suggestion on this would be appreciated. Thanks,
View Replies !
View Related
SSRS--Adding Static Column To A Matrix Report .Plz Help!!
Hi, I need to have a Matix report which looks like : ...............|YEARS -------------------------------- ...............|Class1|Class2|Class3 Programme|StudNo|StudNo|StudNo Column--Years SubColumn--Class1,Class2,Class3 Row --Programme Data --No of Students ie; The Matix will look like this Programme|.......2001.................|........200 2............|. ------------------------------------------------------------------------ ..............|Class1|Class2|Class3|Class1|Class2| Class3|..... IT...........|..23...|...24..|..45....|..12...|..2 3...|..12..|..... MBA........|..34...|...12..|..12....|..31...|..13. ..|..14..|..... I don't know how to split the YEARS' column into 3 different subcolumns which has got class1,class2,class3.Each year has got the 3 different staic column headers as class Names. Under that the no of students in each class comes. The students in each class in each year should be calculated based on some condition which is not available directly from a dataset. Hope u can understand the matix. PLEASE HELP!!! Thanks & regards, Payal
View Replies !
View Related
Adding Subreport Total To Main Report Total
Hi, can anyone help? I have created a Report using Visual studio-the report displays a subreport within it. On the Subjective Report I have 12 values for each month of the year. For the first month the value is =sum(Fields! Month_1.Value), and I have named this text box €™SubRepM1€™ The name of the subreport is €˜subreport1'. On my Main Report, again I have 12 values for each month of the year. For the first month the value is =sum(Fields! Month_1.Value)*-1, and I have named this text box 'MainRepM1' The name of the main report is 'GMSHA Budget Adjustment Differentials' The report displays both of the subreport and main report values but I now need to total these values together for each month in order to produce a grand total. I have tried using the following to add the totals for Month 1 together, =subreport1.Report.SubRepM1 + MainRepM1 but this does not work and I get the following error message €˜The value expression for the text box 'textbox18'contains an error [BC30451] Name subreport1 is not declared'. I feel that it should be a simple matter of adding the two sets of values together but I€™m having major problems trying to get these totals to work. Can anyone help, thanks
View Replies !
View Related
Matrix Report:Adding Average Column/Sorting Based On Last Month/Conditional Formating
I have a matrix report with 2 column SaleAmount and ProfitAmounts by Month like Sale Profit Dealer 5/1/2007 6/1/2007 7/1/2007 5/1/2007 6/1/2007 7/1/2007 A 100 200 300 20 25 15 B 200 250 50 30 45 19 how can i do following 3 things 1)Add Total column for Sale and Average column for Profit 2)Sort report by lastMonth of Sale (here 7/1/2007) High to low 3)if last month of sale(here 7/1/2007) is less than second last month here (6/1/2007) whole row should be red thanks
View Replies !
View Related
Sub-Total % In Matrix
I'm trying to get to something like this: New York London Paris M F M F M F 2007 Wk 31 59% 41% 69% 31% 64% 36% 2007 Wk 32 63% 37% 67% 33% 66% 35% 2007 Wk 33 61% 39% 71% 29% 66% 34% The problem that I have is that I can reference the total for the row: SUM(Fields!total.Value, "matrix_rpt_week") but I don't know how to reference the sub-total for the relevant group (eg London). Once I have this I can use it as the divisor in my calculation. I've tried using InScope but can't get it to return the value I need. Any ideas?
View Replies !
View Related
Sub Total In Matrix
Hi i am using Matrix in one of reports, every thing is cool, but i need one more sub column(like subtotal) which should display Percentage Clearly I developed report in following formate and working Fine c1 c2 c3 c4 (subtotal) Row1 1 2 2 2 7 Row2 0 1 2 3 6 Row3 0 1 3 4 8 (subtotal) 1 4 7 9 21 but what we need is c1 c2 c3 c4 (subtotal) (%) Row1 1 2 2 2 7 33.33% --- (i.e..((7/21)*100) Row2 0 1 2 3 6 28.57% Row3 0 1 3 4 8 38.09% (subtotal) 1 4 7 9 21 Any Hint about this ?
View Replies !
View Related
Matrix Sorting By Total
I've created a pivot table by using a matrix and have totals displayed as the leftmost output column. I'd like to sort so that that highest total is on top, and the lowest on bottom. How do i do this?!
View Replies !
View Related
Keep Total In Matrix When Cells Are Empty
Hi all, I have a matrix with total rows and columns. The data displayed come from an MDX query, which returns empty values to get all the dimension members wether there is a measure value or not. Here is the expression of my cell : =IIF(IsNothing(Fields!Amount.Value), 0, Fields!Amount.Value) This works in the detailed cells but the totals are all set to '0'. How can I keep my totals working ?
View Replies !
View Related
Running Total Across Matrix Groups
Hi I have a report that calculates shipping quantities based on customer orders, and color codes them based on whether or not we have stock for a full shipment (green), have partial stock for a shipment (blue), or if we have none (red). Every week we get customer orders and build accordingly. I have this all worked out except for parts with multiple ship to locations. RS seems to parse the entire row of the first ShipTo, then the second ShipTo. I'm using the running total function to calculate if there is a need or not. Anybody have any ideas? Here is an example of the output I am getting. On the 17th, the 360 should be in green not red. I double checked the grouping, and it is on part number. This is for a matrix. http://img519.imageshack.us/img519/8650/productionqg0.png
View Replies !
View Related
Matrix Report Columns Grand Total
Hi There i have a Report That Display's data in following format Areas Code | Descirption | Emirates | GCC | ASIAN | OTHER ARABS | so on.. 1 What ever 3 0 2 1 2 ABC 0 0 1 0 ------------------------------------------------------------------------------------------- Total 3 0 3 1 The Areas are Matric Columns and are dynamically generated . i dont want sub total of each row , but i want Grand total at the end of the all columns generated by matrix I have no clue how do to it Kind Regards
View Replies !
View Related
Adding Columns To A Matrix Report That Don't Belong To The Matrix Columns Groups
Can we do this? Adding more columns in a matrix report that don€™t belong to the columns drilldown dimensions€¦ That is, for example, having the following report: Product Family Product Country City Number of units sold Then I would add some ratios, that is, Units Sold/Months (sold per month) and other that is the average for Product Family (Units Sold/Number of Product Family), for putting an example€¦ some columns should be precalculated prior to the report so do not get into it, the real problem I don€™t see how to solve is adding one or two columns for showing these calculated column that doesn€™t depend on the column groups but they do for the rows groups€¦ Any guidance on that? The only way I am seeing by now is to set it as two different reports, and that is not what my client wants€¦ Many thanks, Jose
View Replies !
View Related
Adding Columns For A Dollar Total
I was wondering what is the best way to have a amount paid total from amounts entered to a specific id or column? I am using SQL 2005. I need to be able to tally the total amount paid and put that value in another column called amount paid. Any help would be great. Thanks,
View Replies !
View Related
Total In Matrix Not Navigating To Proper Subreport With Correct Parameters
Hi I have a matrix table with Status as the row heading and month as the column heading. The detail is a count off the records which fall into these statuses and the month columns. The detail also contains a navigation link to a subreport which returns the records which make up the count. For example if the detail contains a 7 , when i click on the 7 it returns 7 records with details off these records. The subreport accepts 2 parameters which is passed over from the navigation link, the parameters are - status id and month. My question is - I have put a total on the matrix for the month columns, when i click on the total value the subreport appears (as the total is treated as part off the details) but it does not return the correct number off records. Im unsure as to why the total would not return all records , but it seems it is not passing the month parameter correctly, it seems to not to know to pass 'all' months which appear on the matrix as it is the 'total'. It seems to get confused and returns records only for a particular month. I thought the matrix would be smart enough to know that when a total has a navigation to return all records. Can someone please help thanks
View Replies !
View Related
Placing Sub Total Coulmn To The Left Of The Coulumn In Matrix Report
Hi, If I am taking a Matrix and right clicking on the column header and click on the SubTotal then it always place that column on the right of it .If I want to place that column to the left of my original column then I can't do it. Adding manual column and then puuting the Expresstion =Sum(Fields!MyCol.Value) is not halping as it will give me the same value that is there in the column instead of giving me the column -Thanks, Digs
View Replies !
View Related
How To Add Subtotal In A Matrix Which Shows All Colunms Nut Seletd Vales Of Total
Hi I have a Matrix Like This Sales Type AZ CA ID NV WA OR Total No Surplus 1 2 1 3 4 1 12 Reverted 1 4 2 4 7 2 20 Surplus 2 4 1 2 2 1 12 This "Total" is of All States(AZ, CA, ID, NV, WA, OR). But I Just want the total of just four states i.e(ID, NV, WA, OR). And I also Want that States which are not included in the total i.e(AZ, CA) Should also appears in the matrix , but their values should not include in the total. I have already applied the filter on the subtotal, but (AZ, CA) did'nt appears in the matixr after filter. thanks Regard Mohammad Yaseen
View Replies !
View Related
Matrix With Two Row Groups (one Hidden And Toggled From The Other) - Sub Total Background Colour
I hope I can explain this ok; I have a matrix on my report, with two row groups (sales area and shop) The shop group is hidden and can be toggled by the sales area group. I then have one column group (model) and the field is a sum of sales amount. I have then added a sub total row at the end. All this works fine and the numbers etc all add up, but I have a problem with the sub total background colour. I have found the little green arrow and have set the background colour of the subtotal column to my desired colour. Now the problem........the background colour of the sub total column does not appear until i toggle the second row group (shop) i.e. when the report firsts loads and displays the sales area row group, the background colour of the subtotal is transparent (not grey as i would expect) - when i expand and toggle the shop row group - the background (and font formatting etc) is as expected. I am going crazy trying to work this out, has anyone else had this problem, and if so, is there a fix? Many thanks Chris Lord
View Replies !
View Related
Adding Total To Paramter Drop Down List
I was trying to write an expression someting like this. (CASE WHEN (GroupVar2 IN('CBank','DTC', 'EDirect')) THEN GroupVar2 ELSE 'InstLend' END) AS COALESCE(GroupVar2,'Total') AS GroupVar2 In GroupVar2 column, following values are available; CBank DTC EDirect InstLend Inst-Load I use this for a parameter in my report. I want to consider inst-Load as the same as InstLend. In drop down menu , I should see only InstLend. When I select it, I should get summation of InstLend and Inst-Load. Also I should see 'Total' as one of the available value. So when I select total it should give me summation of all of above. Can anyone help me to write this corretly? Thanks
View Replies !
View Related
Adding Staggered Running Total And Average To Query
Hi,I am trying to add a staggered running total and average to a queryreturning quarterly CPI data. I need to add 4 quarterly data pointstogether to calculate a moving 12-month sum (YrCPI), and then tocomplicate things, calculate a moving average of the 12-month figure(AvgYrCPI).Given the sample data:CREATE TABLE [dbo].[QtrInflation] ([Qtr] [smalldatetime] NOT NULL ,[CPI] [decimal](8, 4) NOT NULL) ON [PRIMARY]GOINSERT INTO QtrInflation (Qtr, CPI)SELECT '1960-03-01', 0.7500 UNIONSELECT '1960-06-01', 1.4800 UNIONSELECT '1960-09-01', 1.4600 UNIONSELECT '1960-12-01', 0.7200 UNIONSELECT '1961-03-01', 0.7100 UNIONSELECT '1961-06-01', 0.7100 UNIONSELECT '1961-09-01',-0.7000 UNIONSELECT '1961-12-01', 0.0000 UNIONSELECT '1962-03-01', 0.0000 UNIONSELECT '1962-06-01', 0.0000 UNIONSELECT '1962-09-01', 0.0000 UNIONSELECT '1962-12-01', 0.0000 UNIONSELECT '1963-03-01', 0.0000 UNIONSELECT '1963-06-01', 0.0000 UNIONSELECT '1963-09-01', 0.7100 UNIONSELECT '1963-12-01', 0.0000 UNIONSELECT '1964-03-01', 0.7000 UNIONSELECT '1964-06-01', 0.7000 UNIONSELECT '1964-09-01', 1.3900 UNIONSELECT '1964-12-01', 0.6800 UNIONSELECT '1965-03-01', 0.6800 UNIONSELECT '1965-06-01', 1.3500 UNIONSELECT '1965-09-01', 0.6700 UNIONSELECT '1965-12-01', 1.3200I am trying to return the following results:Qtr CPI YrCPI AvgYrCPI-------- ----- ----- --------1-Jun-60 1.481-Sep-60 1.461-Dec-60 0.721-Mar-61 0.71 4.371-Jun-61 0.71 3.601-Sep-61 -0.70 1.441-Dec-61 0.00 0.72 2.531-Mar-62 0.00 0.01 1.441-Jun-62 0.00 -0.70 0.371-Sep-62 0.00 0.00 0.011-Dec-62 0.00 0.00 -0.171-Mar-63 0.00 0.00 -0.181-Jun-63 0.00 0.00 0.001-Sep-63 0.71 0.71 0.181-Dec-63 0.00 0.71 0.361-Mar-64 0.70 1.41 0.711-Jun-64 0.70 2.11 1.241-Sep-64 1.39 2.79 1.761-Dec-64 0.68 3.47 2.451-Mar-65 0.68 3.45 2.961-Jun-65 1.35 4.10 3.451-Sep-65 0.67 3.38 3.601-Dec-65 1.32 4.02 3.74Note, 4 data points are required to calculate a moving sum of CPI(YrCPI) and 4 calculate YrCPI figures are required calculate theannual average of YrCPI (AvgYrCPI), giving a staggered effect to thefirst 7 resultsThis sad effort is about as far as I've got:SELECT I.Qtr, I.CPI, SUM(S.CPI) AS YrCPIFROM QtrInflation IJOIN (SELECT TOP 4 Qtr, CPIFROM QtrInflation) SON S.Qtr <= I.QtrGROUP BY I.Qtr, I.CPIORDER BY I.Qtr ASCCan anyone suggest how do achieve this result without having to resortto cursors?Thanks,Stephen
View Replies !
View Related
Adding A Time Column To A Date Column
I have two columns in a table:StartDate DateTime and StartTime DateTime.The StartDate column holds a value such as 07/16/2004The StartTime column holds a value such as 3:00:00 PMI want to be able to add them in a stored procedure.When I use StartDate + StartTime I get a date two days earlier than expected.For example, instead of 7/16/2004 3:00:00 PM StartDate + StartTime returns7/14/2004 3:00:00 PM.Can anyone point out wht I'm doing wrong with this one?Thanks,lq
View Replies !
View Related
Adding Column To A Table Before An Existing Column
I simply need the ability using SQL to add columns in an existing table before (or after) columns that already exist. The MS SQL implementation of ALTER TABLE doesn't seem to provide the before or after placement criteria I require. How is this done in MS SQL using SQL or is there a stored procedure I can use? Thanks.
View Replies !
View Related
Calculate Total Tuition By Accumulating Column Values ( Loop?)
I am trying to create a procedure which will calculate the total tuition This process involves 3 tables. Contract table has tuition information which is all $100 (set price). Discount table has discount type and discount percentage (ex. 0.3) on each discount type. ContractDiscount table have contract number and discount number to connect both tables I think I need to create a loop since some contract gets more than one discount. I have to calculate and get result nee to be like this total_tuition = (tuition - discountPer * tuition) - this has to be a loop condition Do you have any suggestion ? Thanks
View Replies !
View Related
Sum Of A Column In Matrix
hi reporters! i m using matrix in my project and i want to calculate the (cell_value/sum_of_column). for data cell values we have to use sum or another aggregate function for subtotaling, so for the cell value i m wirting sum(column) / A. how to write A that points to sum of all cells on the column. x_column y_column z_column sum(y_column)/A A?
View Replies !
View Related
Using Matrix : Avg Of A Column Group
I'm using Matrix Report item to convert the values from a column into columns of the matrix (crossed reference query) and then I need to have and extra column (it has to be at the very right) containing the avarage of the values of such columns. I've noticed that it is possible to get the Subtotal of a column group, but I haven't seen the avg option. Is it possible? If not, any idea? thanks a lot
View Replies !
View Related
Extra Column In Matrix
Hello, I'm trying to make a report with the following layout: Car Sales 2004 2005 Var % Total 10 20 50% Green 7 14 50% Red 3 6 50% I'm using a matrix and the data is coming from a cube. One dimension called 'Years' is used to fill the matrix columns and the data corresponding to the car sales is filled by a measure called 'Sales'. I've built part of the example but I can't add the final column ( the VAR% column). If I try to add a static column in the end it apears only one year. The behavior that I would like to have is simillar to the situation when we add the Subtotal column. Although, instead the sum() made by subtotal I would like to calculate the variation percentage between years. Is there any way to add a final column into a matrix avoiding the problem that I'm having or maybe change the behavior of Subtotal column? Thanks and best regards. vjn
View Replies !
View Related
Matrix Column Visibility
Hello, I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5. But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects. I have RS 2005. Thank you for any idea. Jirka Nouza
View Replies !
View Related
Column Names On Matrix
Hi, Is there any way of having Column names in a matrix report. Actually it is a RowGroup. I want to display the name of the row group at the top, so that the user understands what is the data beneath. regards Josh
View Replies !
View Related
Holding Matrix Column
I'm developing a report where the user is able to select a bucket size and have the dataset grouped based on the value in a record and count the number of records that fall into that bucket. The example below is a bucket size of 12. the first row is the value range and the second is the record count. 0 - 6 6 - 12 12 - 18 18 - 24 24 - 30 30 - 36 42 - 48 68 10 9 33 5 4 4 The problem i have is, if there is no value for a range that value range is missing as above there is not 36-42 with a rec count of 0. here is the expression i use in the column group to create the groups dynamically based on the user input. switch(Fields!REL_TURN_HRS.Value < Parameters!bucket_size.Value,1,Fields!REL_TURN_HRS.Value >= Parameters!bucket_size.Value and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *2) ,2, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *2) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *3) ,3, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *3) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *4) ,4, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *4) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *5) ,5, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *5) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *6) ,6, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *6) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *7) ,7, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *7) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *8) ,8, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *8) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *9) ,9, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *9) and Fields!REL_TURN_HRS.Value < (Parameters!bucket_size.Value *10) ,10, Fields!REL_TURN_HRS.Value >= (Parameters!bucket_size.Value *10) ,11)
View Replies !
View Related
How To Add Column In Matrix Table???
i have problem to add column in table matrix. the problem is how i can to insert the total for every division value. please refer the images http://www24.brinkster.com/alumnismkap/matrix.bmp (if cannot open please open new window browser- copy n paste this url) i want to insert the total value between another division.ok thanks for ur helping..THANKS
View Replies !
View Related
Percentage Column In Matrix
Hi, I would like to generate following table with reporting service matrix. But if I use the expression : percentage coulmn=sum(field!qty.value) / sum(field!qty.value, "region_group") It will become a percentage of a row total, instead of a group total (store group). Please see the second table. Any ideas? Thank you! (Correct!) store1 store2 level1 level2 level3 sub total level1 level2 subtotal category region qty % qty % qty % qty % qty % qty % qty % C1 APAC 10 10% 20 20% 70 70% 100 100% 25 50% 25 50% 50 100% EURP C2 CHINA (Wrong) store1 store2 level1 level2 level3 sub total level1 level2 subtotal category region qty % qty % qty % qty % qty % qty % qty % C1 APAC 10 6% 20 13% 70 46% 100 25 16% 25 16% 50 EURP C2 CHINA
View Replies !
View Related
Matrix Column Aggregations
Quick question for you pro's... Within a report matrix, I want to be able to have different aggregations for totals. One column would be a Sum of the data in that column, the next column would be an Average of the data. Is this possible, or is this not supported in SSR2005? Thanks in advance for your help, Clint
View Replies !
View Related
|
TRACKER
