Pivot Table Source Data

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

I have an existing Pivot Table that usually updates daily, albeit this
relies someone in the office refreshing the data. Anyway we seem to
have missed one days data and thought we would be clever and just
include the days missing data back into the source data. In effect we
are putting the 8th September data between the 7th and the 9th. However
no matter what we do the data from the 8th ends up as the last column
in the pivot table. Are we missing something really simple here or has
my brain turned to mush?

thanks for the help in advance.

Bryan

P.S I also tried creating a dynamic range but it still did not work.
 
Hi Bryan

it sounds as though you need to sort the field by Date in the PT.
Double click on the Field label, Advanced and choose Ascending

Regards

Roger Govier
 
Roger said:
Hi Bryan

it sounds as though you need to sort the field by Date in the PT.
Double click on the Field label, Advanced and choose Ascending

Regards

Roger Govier
Click to expand...


Roger,

You were spot on. Thanks :)

BRyan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Pivot table report invalid 0
Pivot Table Source file 2
Analysing Percentages in Pivot tables in Excel 2003 2
Excel Error while updating an external data source into a pivot table! 0
pivot table loosing decimals (vba) 1
making an excel table visible for external data on pivot table 1
Pivot Table w/ Access data 3

Back
Top