Hi Bill,
thanks for the Series. I've struggling with an odd problem with comparing the results in Excel. When I copy the filtered results across and apply the Auto-Average Function I get a higher value then I do using PowerPivot. I added the values and the sum is also higher in Excel than PowerPivot. I then created a simple pivot table on the Re-seller sales amount filtered by the Order Date Key and that returned the same value as PowerPivot. Could you shed any light on why this might be?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537