1 Reply Latest reply on Jan 29, 2018 8:44 AM by arvindgarg

    How to display date values that are not in primary data source?

    Adam Kaufmann

      I'm looking to display company sales against a monthly goal with all 12 months showing in the chart.  The sales are pulled from a SQL table and the goals are from an Excel workbook, with the two linked by "Effective Date."  Since there haven't been sales in the remaining months of the year, I haven't been able to get those months to show in my charts or tables, thus I can't see the remaining goals to be hit.

      I'd appreciate any insight on this.  Thanks!