First it is generally better to reshape your data so you don't have weeks running across the page. Here's what your data looks like after reshaping:
Group Week Value Test 1 Week 53 6 Test 1 Week1 26 Test 1 Week 2 13 Test 2 Week 53 3 Test 2 Week1 35 Test 2 Week 2 20 Test 3 Week 53 10 Test 3 Week1 42 Test 3 Week 2 4
If you are working in Excel this reshaping is easy using a Andy's reshaper add-in. After you've got it reshaped then when you bring the table in the Weeks come in as a default text string. If you leave it as a text, then you can group it the way you wanted to:
Week Groups.twbx.zip 8.6 KB
I needed your help regarding a related question to group the same data in a different way. Please let me know if you want me to start a new discussion.
What I wanted to do is to group data on the most recent week, a week prior and than all records greater than two weeks.
So, for this data:
Week2 would be the "Most Recent Week" and total Value would be 103
Week1 would be "1 Week Prior" and value would be 37
and last group would be "Greater than 2 weeks" and value would be 19
I wanted to do this dynamically and assume week groups based on the last date update in data rather than system date.
Can you please help me find a solution for this.. I have tried searching the forums but I could not find anything that could help me.
Thanks for your time.
I searched archives but was not able to find a solution to my problem.
Can you please help me get the Date Groups..