I have a qvd file which has traffic for daily level basically it has the traffic for a single day for each hour for each location.
Now, i have to use this QVD and create another one such as this one should give me the total traffic for the week for all stores.( the whole traffic should be set to the first day of the week i.e. the first day of every week will give me the total for that week)
Attached is my QVW which i am working on, I am joining this one to Date QVD which may help us to aggregate it to week level and the date one has all the date fields required.