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.