I have a view that gives me the following information from some tables.
Cust # Cust Name Date Order Type
001 John Doe 20070401 OR1
002 Miss Doe 20070401 OR2
001 John Doe 20070402 OR2
002 Miss Doe 20070402 OR2
What I would like to do is set up a matrix type report. The report is by the last 6 rolling order dates, with some % columns. So two row examples might be
Cust# Cust Name 20070401 20070402 % (of last x = OR1) %(of last x = OR2)
001 John Doe OR1 OR2 50% 50%
002 Miss Doe OR2 OR2 0% 100%
Another column just like the last two % based off a 3rd type, and finally a total % column that simply adds the 3 columns up (should always equal 100%, just an error check)
First, can this be done with a matrix? I tried a table but it lists cust# twice, but I can be doing it wrong. I am ok doing this within the query if need be, if someone gives me a hint how
Thanks,
When you tried the table, did you set a row group on the customer number?|||Yes, and it will not give me a column for each date in table form.
No comments:
Post a Comment