then insert a pivot chart/table into a new sheet and go crazy.<BR><BR>So that's great and all... EXCEPT I have no way to SHARE that love.<BR><BR>I want to let end users basically consume SQL ...

I can't seem to get anything to work My table (tbl_Promotions) has 3 columns which I'd like to create the pivot from If I create a temp table which has the 52 calendar weeks of the year ...

You poured data into a pivot table. Now what? Make them smarter. Here's how to use Summarizing Data and Calculated Fields in order to get a different perspective on your marketing data through the ...