Pivot table dates range display problem

[#1]

hi folks,

i have data from 2012 jan 1-29 days.

my problem is to show the dates range as 1-7  8-15  16-23   like that

i tried calculated dimension as--   date(weekstart(salesdate),'m.dd')&'-'& date(weekend(salesdate),'m.dd')

expression: sum(sales)

problem: its showing dates range from 26-1,1-8.....23-29.

requirement: range should start from 1st day of january

may be its problem in date format , i used subfield to achieve the desire date format

where exactly the problem

plz help me out

[jagan]

Hi,

Attach the sample document, will help in fixing the issue.

Regards,

Jagan.

[#3]

hi gurus,

plz find the attached sample qvw.

in week off  how to stop date range upto jan month only , not into feb

[#4]

Hi,

Please check attachment.

I hope this is what you want.

[#5]

hi ravi,

here iam missing one date value

plz find the attached qvw

Thanks in advance

[#6 · Accepted solution]

Hi,

Please refer to attachment.

[#7]

hi ravi, jagan

ur right , its worked for me

Thanks for quick responce