I am looking to create an area chart graph that shows data from a SQL server and data from an excel Pivot table (in a single graph).
When importing the excel file, I receive a message saying I need to edit the relationship between the two data sources.
When attempting to edit the relationship and secondary data source field, I am only presented with one option "Date," even though there should be additional fields.
It is very hard to know why you are only seeing the Data in the secondary list, without actually seeing your data/workbook. Can you mock up an example .TWBX using some sample/randomized data?
To be clear, what fields are you hoping to establish a relationship on, if not Date? Any more detail you can provide on what you're hoping to achieve may also be helpful.