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

I have found one way of doing this, yet I have yet to implement it... by now I have eliminated the matrix report and only doing a normal one with drilldown at the row level.

The way of doing this, exposed on some articles through the web is to put a higher level group that is unique and there insert the corresponding columns..

Well if anybody knows of a nicer way to do this, please say so...|||

Hi

Saw this and i dont know if this is what your looking for
but it seemes like you may be able to implement this.

Quote Robert Bruckner MSFT :

" You can use the InScope function to distinguish subtotal cells from other cells. Please check the MSDN documentation about the InScope function:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_0jmt.asp
With InScope you can determine the current scope of a matrix cell (e.g. in subtotal or not). You would use an IIF-expression to set the cell expression based on the InScope return values. Note: a matrix cell is "in scope" of column and row groupings, so you need at least two InScope function calls in the case where you have one dynamic row and one dynamic column grouping. E.g.

=iif(InScope("ColumnGroup1"), iif(InScope("RowGroup1"), "In Cell", "In Subtotal of RowGroup1"), iif(InScope("RowGroup1"), "In Subtotal of ColumnGroup1", "In Subtotal of entire matrix"))

Replace "In Cell" with =Sum(Fields!Amount.Value)
Replace "In Subtotal..." with =Avg(Fields!Amount.Value)

However, note that since the subtotal cells share the same cell definition as the group instance cells, adding two "subtotals" (one for "Total", the other for "AVG") at the same level is not supported. One way of solving this is to add a rectangle into the matrix cell and use two textboxes to show the total and the average. Then use conditional visibility on the average textbox to only have it visible for subtotals."

Sorry Robert for quoting you, I couldn't get the thread linked...

G

|||thanks!!

Sorry I already tried to use InScope... I also tried to set up a higher grouping but that only does more confusion and servers for only one more value, when I need three or four... not quite desirable...

Thanks so much for your answer!
Jose