Tuesday, August 31, 2010 2:49 PM
I'm looking at using PowerPivot to link a list of customers we have emailed to any sales they have made since the emailing. This is very straight forward to do. However PowerPivot groups together any sales made to customers who have not been emailed into one entry which is blank.
I have linked the sales data set email field to the email data set and then used the email field from the email data set on the Pivot.
Can anyone suggest a way of tidying this up?
I can create a calculated column in the emailing data set with a static value and then use this as a filter in the Pivot but I'd like to see sales to customers we've mailed versus those we haven't.
I hope this makes sense!
Thursday, September 02, 2010 5:31 PM
I recommend using the "SQL Server PowerPivot for Excel" discussion alias for this type of question. That will have more people on it who can help you with questions like this.
Friday, September 03, 2010 1:38 PM
Good Point - thanks Lee.