Hello,


I'm trying to produce a pivot chart using multiple queries. I have one main query which displays all of my job due dates from this date onward and consecutive tables that display job due dates for individual customers in a similar fashion. I've created relationships using the account numbers between all of the table data and created main query that calls all of the due dates into one spot. I change view to pivot chart and proceed to drag the "DUEDATE" field from each call to the Category field and the pivot chart goes wacky. I switch to pivot table and I see "Error in the metadata manager...ID of the attribute is not valid because this ID is a reserved word..." Note that all the pivot tables work on there own. Can someone tell me what I need to do to get this to work and if this is the most efficient way to make a pivot chart to compare data in this way on one chart?