Getting the maximum date per week

[#1]

Hi All,

I have here a table in which I need to determine what is the maximum date per week.

Please see below:

Date	14/9/2014	15/9/2014	16/9/2014	17/9/2014	18/9/2014	19/9/2014	20/9/2014	21/9/2014
WeekName	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun
A
B
C

For example, the starting week is = Mon, End week = Sun. So I only need to sumup all the values from Mon-Sun then put it in the cell 21/9/2014 (Sun). All the other fields are 0 and only the Sunday will have the value. Unless the last day of the week is not sunday; for example the last day of the week is 18/9/2014 then it will accumulate Mon-Thursday only and the data should be inside the cell Thu.

I hope you get the idea. Feel free to ask questions. Thanks - Lyn

[#2]

bump!

[sushil353]

Hi,

First of all you can load data using crosstable load.. to transform your data.

Then you can eaisly findout weekend date of each date.. then you can simple put the weekend in your chart axis or can do groupby.

HTH

Sushil