Hello,
I've setup a pivot table using data from an Access query. I'm trying to get the data in the pivot to sort in a specific order so the pivot charts look correct. The issue is that I'm trying to sort by year and week number. I thought it would be easy but, for whatever reason, while using the pivot that's connected to the Access query, each year shows week numbers that it shouldn't. So, I started this back in September. For 2017, I should see week 35 thru 52 in my pivot table. For 2018, I should just see the one week. Instead, for each year, I see each week.
I then recreated a small version of this in Excel and created a pivot that works the way I expected.
So if my two columns are:
My pivot table looks like this:
However my pivot that sourced from the query looks like this:
Why would it include all of those extra rows for either year? There is no record with a combination of week 1 and year 2017 as well as no weeks 2-3 in 2018.
Is this just some weird way pivots work when you're sourcing data from MS queries.
Thank you,
Roger
I've setup a pivot table using data from an Access query. I'm trying to get the data in the pivot to sort in a specific order so the pivot charts look correct. The issue is that I'm trying to sort by year and week number. I thought it would be easy but, for whatever reason, while using the pivot that's connected to the Access query, each year shows week numbers that it shouldn't. So, I started this back in September. For 2017, I should see week 35 thru 52 in my pivot table. For 2018, I should just see the one week. Instead, for each year, I see each week.
I then recreated a small version of this in Excel and created a pivot that works the way I expected.
So if my two columns are:
Code:
Week Year
1 2018
2 2017
3 2017
4 2017
My pivot table looks like this:
Code:
Year Week
2017 2
3
4
2018 1
However my pivot that sourced from the query looks like this:
Code:
Year Week
2017 1
2
3
4
2018 1
2
3
4
Why would it include all of those extra rows for either year? There is no record with a combination of week 1 and year 2017 as well as no weeks 2-3 in 2018.
Is this just some weird way pivots work when you're sourcing data from MS queries.
Thank you,
Roger