title: Exporting joined list from sharepoint to excel
body: <p>I have two lists in sharepoint: one list is a customer list with customer id, name and state, the other is an order list that has a lookup column that refers to the customer id, order date and order amount.  I would like to join both lists on customer id and export the joined list to excel so that I can create a pivot table that, say, lists sales by state.</p>
  
  <p>I'm able to create a linked datasource using the sharepoint designer.  I haven't been able to find a way to export that to excel however.  Can someone offer advice?</p>
  
  <p>Regards</p>