|Subject:||Correctly Identify Seasons|
|Posted by:||iamnu (iamnu…@gmail.com)|
|Date:||Sun, 20 Jul 2008|
I have a spread sheet that has daily weather information.
I have a column "Seasons" that specifies if the date is "Summer",
"Fall", "Winter" or "Spring".
Since Winter begins on ~December 21 and ends on ~March 21, my Pivot
Table is showing the wrong information for "Winter", because it is not
using December values from the previous year.
Can someone give me a suggestion as to how to "fix" my spreadsheet to
properly display the "Seasons" information in a pivot table?