I have a list report to create either from relational data or a cube in this format.
Customer Product. 2013/05/14. 2013/05/07. 2013/05/01 .......
John. Item A. 25. 38. 52
Joe. Item B. 87. 0. 42
The list is by customer/product of quantities sold by week.
The week column headings are for the last 52 weeks.
I'm kind of stumped on the how to do the week columns.
Hi t1701,
I think it is better to define the week columns in tables, per your example, you need to add a new column for every new week
I think it is better to go for crosstab with some formatting to make it look like a list.
Hi,
I can't define the weeks as columns in a table since they change from week to week as new data is added.
Right now, in the table, there is a column called Week_Ending with the week number.
In SQL, I can pivot it around but I can't use that in Framework Manager since it's not static, i.e. the weeks change.
How would I create a cross-tab but have it look like a List?
Quote from: tstjean on 15 May 2013 07:04:32 AM
How would I create a cross-tab but have it look like a List?
This post by PaulM is a great technique that might solve your problem.
http://www.cognoise.com/index.php/topic,11363.msg64116.html#msg64116