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 |
|
DavisJ44
Starting Member
9 Posts |
 Posted - 2009-05-18 : 17:25:31
|
| Currently I have a matrix report and would like to build a new field from the fields in the matrix. Is this possible?It is easy to build new fields from fields that are in a "Table" report, but I'm having trouble doing this with a Matrix.Thanks in advance... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-19 : 10:38:49
|
| new field from fields? can you explain that? do you mean to add a new derived field? |
 |
|
|
DavisJ44
Starting Member
9 Posts |
Posted - 2009-05-20 : 18:30:50
|
| Yes, when a create a "table" report it is easy to take existing columns in the table and derive or build new fields from them. However, when I build a matrix report I haven't figured out how to derive new fields from the existing one.For instance suppose I'm looking at year end sales across County and my dataset has three columns.County, Sales, YearEndIt's easy to take this dataset and build a matrix(Pivot) that has county in the first column sales for 2005 in second column sales for 2006 in third column and so on. However, what if I want to know the growth in sales for 2006? I would like to take the 2006 column and divide it by the 2005 column, but I don't know how to do this because it is in a matrix and the 2006 and 2005 columns exist in the report, but not in the dataset.If I instead would have started with a dataset that looked like this:County, Sales05, Sales06, Sales07, Sales08then I would have created a table report and the in the report it would be simple to derive a new data field from the dataset that took Sales2006/Sales2005.I would use the table data everytime, but it is not always a simple matter to pull my dataset in table format.One work around is to create the pivot in the query then build a table report, but it would be nice to skip this step. |
|
|
|
|
|
|
|
|
New Fields from Matrix Fields