S
smonczka
Date problem in Pivot Tables when using SQL as a Data Source.
I have a table of sales information in SQL that shows the week ending
totals for our sales and the total sale price for that week. I am
using Excel to create a pivot table to access this table information so
that end users can automaticly look up the total weekly sales at any
time without having to come bother me I am not having any problems
making the pivot table and connecting to the SQL data. But all dates
come in as numbers, i.e. 1/4/2006 would show up as week "1" or
quarter "1" or day "4" but not 1/4/2006. The problem is when I
create a pivot tables with week ending sales totals each week in the
table shows up as a number, 1 - 52 and this confuses the users. What
I want to show is the actual week ending date not the number of the
week. Is this possible?
Thanks
Steve
I have a table of sales information in SQL that shows the week ending
totals for our sales and the total sale price for that week. I am
using Excel to create a pivot table to access this table information so
that end users can automaticly look up the total weekly sales at any
time without having to come bother me I am not having any problems
making the pivot table and connecting to the SQL data. But all dates
come in as numbers, i.e. 1/4/2006 would show up as week "1" or
quarter "1" or day "4" but not 1/4/2006. The problem is when I
create a pivot tables with week ending sales totals each week in the
table shows up as a number, 1 - 52 and this confuses the users. What
I want to show is the actual week ending date not the number of the
week. Is this possible?
Thanks
Steve