3 of 4 people found this helpful
You CAN use the Measure Names and Measure Values meta data entity from the PRIMARY data source and then ADD in the Secondary data source measures to it.
I don't understand how this workbook addresses the issue because both measures (profit and sales) appear in both data sources you have included in the worksheet. I am trying to use the measures name filter functionality with two data sources. "Budget" is only contained in an Excel file data source. Current Year Actuals and Prior Year Actuals are housed in a corporate transnational data source. My goal is to show CY Actuals as bars, with a line for PY Actuals and a line for Budget. I have been unable to figure out how to show three measures in one chart (using two linked datasources).
Cindy, If you can provide some sample mock data in a workbook I will be glad to help.
Were you able to solve the issue you had posted about? If so, could please share the solution? I'm trying to do the same thing you were trying to accomplish. Any insight would be very helpful!
Just drag the pill with the measure you want to include from the secondary source into the Measure Values shelf.