How to tidy "unlinked" data in PowerPivot?

Question

Dear all,

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!

Thanks,

Matt

Answer 1

Hi Matt,

  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.

Thanks
Lee

---

Lee Graber

Answer 2

Good Point - thanks Lee.

 

Matt