Excel PowerPivot import is not displaying 2013 data by week anymore

DigitalRhoads

New Member
Joined
Jan 28, 2013
Messages
4
We use a PowerPivot table to import website data to a large workbook. On the main report tab, the information is broken out by "Year" and then by "Week" (1-53). When 2013 began (and 2013 data was imported), the year 2013 automatically appeared on the reports, BUT this data is no longer broken out by week. The data is just aggregate totals for the year. As we import new data each week, the 2013 aggregate grows, but the data is not listed out by week for 2013. All fistorical data for 2008-2012 is still broken out by week appropriately.
How do I get 2013 to show data by week again?
Thanks on advance for any help!
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Does the week still appear in the pivot table? Did your date table change? ...

Nothing has been changed. The weeks still appear in the Pivot Table and all data prior to 2013 is still displayed by week (which we feel is odd considering each 'refresh' imports ALL historical data, not just the new data). Everything for 2008-2012 lists out by week collapsible by year, then 2013 just displays an aggregate total for the year - no breakout by week. Same format for imported data, no modification of the pivot table, merely a new year.
Thanks!
 
Upvote 0
What measures do you have in said report? How is this measure defined? How do the data in the Week column look like for the year 2013?
 
Upvote 0

Forum statistics

Threads
1,215,590
Messages
6,125,701
Members
449,250
Latest member
azur3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top