Matrix Issue

Question

Post reply

Matrix Issue

Warren Wickline

SSC Rookie

Points: 28
More actions
April 12, 2007 at 2:32 pm

#177345

I am trying to make a matrix and I am running into problems. First part works just fine.
             DATE1       DATE2        DATE3
STORE1      X             X               S
STORE2      X                              S
STORE3      S             X               X
This part of the matrix works great But now I would like to add 3 colums on the right side. First column is the % of 'X', second column % of 'S' and last column would be the blanks.
             DATE1       DATE2        DATE3    %X     %S     %()
STORE1      X             X               S       66%    33%    0%
STORE2      X                              S       33%    33%   33%
STORE3      S             X               X       66%    33%    0%
Any idea how I can acomplish this? Right now I am exporting my matrix report to excel so I can add those last 3 colums

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

hawkeyeboy Old Hand Points: 340 More actions · Answer 1

Hi Warren,

One method I've used is a sub-report. In my case I had a matrix that displayed sets of data for each month by user:

Jan 2007 Feb 2007 Mar 2007

Actual Projected Actual Projected Actual Projected

User1 X X X X X X

User2 X X X X X X

User3 X X X X X X

sum(X) sum(X) sum(X) sum(X) sum(X) sum(X)

sub-report here:

category 1 sum(X) sum(X) sum(X) sum(X) sum(X) sum(X)

category 2 sum(X) sum(X) sum(X) sum(X) sum(X) sum(X)

.

I let the matrix calculate the totals but the report request also asked that the totals be broken into separate categories, so I used a sub- report, with the same query behind only summing data different, to display the category totals beneath the matrix.

I think you could do something very similar with your situation.

Hope that help -

Sam Peascod SSCrazy Points: 2497 More actions · Answer 2

I started out using matrices but soon found that tables are far more flexible. Have you tried using a table instead? You can then add a column and formulae as required.