adding more data to pivot table.
I add data to an exsisting pivot table every day and month. When I added a
new month, it added the new data to the bottom of the pivot table instead of
adding it to the correct column. example:
Jan Feb Mar Apr
John Smith 5 2 6
April Jones 2 1 4 3
John Smith 2
B. Smith 3
Why does it add below and not at top under the month? I've tried the
options, doesn't fix it.
|