Weekly Data Display

[rahulsingh12]

Hi I have a condition where I get daily sales data.

if I select 7 it is my Week1 and if I select 9 it is my week2.

I want to show a weekly sum of sales in the bar chart.

But the only catch is if I select 9 i should get data as for week1(1-7) and week2(8-9)

similarly if i select 28 i should get week1(1-7),week2(8-14),week3(15-21),week4(22-28) clubbed.

Regards,

[dsharmaqv]

Try this

=Week(Date#(Date,'DD MM YY')) as Week_No,

[rahulsingh12]

Hi

i dont want to display weeknumber but the sum of sales till the date is selected

[dsharmaqv]

can you post the sample data with expected output pls