GetPivotData help please!

[agroumoutis]

Hi this is my first post so if I'm doing this wrong I apologize. I have an issue with pivot tables (I'm not very good yet). I have an oracle database connection with the excel and as it pulls the data in, I have the pivot table breaking it down into each week. I need to be able to pull specific information for quarterly numbers. For example week 1 through week 13 would be QUARTER 1. So I need to sum the correct weeks of data for the formula. I'm just not sure how to approach this. I'm worried because new data comes in every week so it shifts the table to make a new week and I feel as if I will lose the correct data. I need a way to make it so excel knows what the criteria is for that quarter (week 1-13 = quarter 1, week 14-26 = quarter 2 ETC... Any advice?

 

[liveinhope]

2 questions
1. what version of excel are you using ?
2 Does you database have week number and quarter in it or you using pivot tabe grouping to set week numbers and quarters

 

[agroumoutis]

Thanks for the reply. I'm using excel 2010. And the database does NOT group the quarters. But does have a week number which is one of the column headers in the pivotTable. I just need to group them even though they don't exist yet. For example right now we are in week 4 but I still want excel to know that when we do hit week 15 or 48 etc.. that it should be classified in that quarter.