I have the following fields in my Excel 2007 pivot table field list.
SaleDate
Amount
I'd like to add a field that is calculated from SaleDate using a formula =WEEKDAY(SaleDate)
(or something that can transform the date in that column to a weekday). The result will be.
SaleDate
Amount
SaleDay
After I add SaleDay
to a Row Labels and Amount
to Values, the result might look like this.
SaleDay | Amount
------------+-------
1 | 15646
2 | 851562
3 | 515155
4 | 613215
5 | 516846
6 | 511662
7 | 25165
------------+-------
Grand Total |3049251