List with dynamic column headings

[t1701]

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.

[Jiayue.lin]

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

[raj_aries]

I think it is better to go for crosstab with some formatting to make it look like a list.

[terry_stjean]

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?

[Lynn]

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