If I create a temp table which has the 52 calendar weeks of the year, how can I get those 52 weeks to list across the top as columns. Then I want each row as the Item.

Using the OLE DB Provider for SQL Server/Analysis Services, the end-user can connect to a Data Source directly and build a Pivot Table or PivotChart using standard Excel functionality.

We’ve previously covered a few basics for pivot tables, a powerful Excel tool which helps digital marketers organize and understand data. Today we’re going a half-step beyond the basics of setting up ...