Pivot Table - Help

[K m]

I need to track some weekly fuel usage data.

I have a three part question:
- How do you set up a pivot table to group by weeks? I included example data. The first week should be between 3-17 and 3-23, the second week should be between 3-24 and 3-30, etc.
- I want the pivot table to be dynamic so as I add weekly data, the pivot table expands accordingly
- I want to also have a dynamic pivot chart. I assume it would be easy if I set up a dynamic pivot table.

The information, I am interested in is for each user - miles per gallon, fuel cost, total miles driven tracked weekly

I could set up the data so each tab could represent one week with one master summary

For example, USER Vaughn used XX number of gallons, YY fuel cost and ZZ miles driven for the week 3-17 to 3-23

Any help is appreciated.

[dilipandey]

Hi KM,

see the attached file where I used a defined name "data" to achieved the desired dynamic chart and pivot.

Press ctrl + F3 to see the defined name and its formula.

test.xlsx

Regards,
DILIPandey
<click on below * if this helps>

[Mandy11]

Can you save this in a 2003 spreadsheet so I can see how you did it?

[dilipandey]

Okay.. here you go :-

test.xls

Regards,
DILIPandey
<click on below * if this helps>