weekly report

[Anonymous]

hi gurus,

my source file format is like this

account  1-jan  2-jan  3-jan .................                            31-jan

1            100    200    300                                               500

2             500    600   500                                                800    

3             500     400   600                                                900

required format in straight/pivot table

week of  1.01 -1.06   1.07-1.14 ............1.25- 1.31

                 1200        1500                    2000

how can i achieve this by adding day wise data

[Anonymous]

Hi Joshi

Please attach your template and i'll try to help you.

JF

[anderslinden · Accepted solution]

Hi!
Helped you with almost this last week. Here is a new example.

[Anonymous]

here is my qvw.

the example given by enders is correct but its not working for my data

where exactly the problem