ysquared86
New member
- Local time
- Today, 06:26
- Joined
- Nov 7, 2008
- Messages
- 9
I (a total noob, i know) am trying to generate a pivotchart in a query that shows [quantity shipped] v. [month] relationship for each [product] in our database. However, the months in which no shipments are made do not show up on the pivottable/pivotchart, and i was wondering how to get all the months displaying.
for example, let's say product A has only been shipped out in april, august and july...then the chart only shows the quantity shipped for these three months. i want it to display january, february, etc...with quantity value of 0.
i hope that's not too vague. i feel like if you read above, you can get a gist of what i'm trying to do, but gurus seem never to fail to make beginners feel stupid by telling them how non-specific they are being first...
but please help.
for example, let's say product A has only been shipped out in april, august and july...then the chart only shows the quantity shipped for these three months. i want it to display january, february, etc...with quantity value of 0.
i hope that's not too vague. i feel like if you read above, you can get a gist of what i'm trying to do, but gurus seem never to fail to make beginners feel stupid by telling them how non-specific they are being first...
but please help.