4 Replies Latest reply on Jan 13, 2017 8:45 AM by Jane Hunt

    How to display two data from different data source

    Jane Hunt

      What will be the best way to display the following information based on the requirements?

       

      Requirements:

      The data should be displayed in crosstab.

      Actual data should be displayed from past to the current (coming from data source A)

      Target data should be displayed from the future (coming from data source B)

      Data source A only contains data from past to current.

      Data source B only contains data about future.

      Category20152016Current1Q2Q3Q4Q
      Category AAActual Data(from source A)Actual Data(from source A)Actual Data(from source A)Target Data(from source B)Target Data(from source B)Target Data(from source B)Target Data(from source B)
      Category BBActual Data(from source A)Actual Data(from source A)Actual Data(from source A)Target Data(from source B)Target Data(from source B)Target Data(from source B)Target Data(from source B)
      Category CCActual Data(from source A)Actual Data(from source A)Actual Data(from source A)Target Data(from source B)Target Data(from source B)Target Data(from source B)Target Data(from source B)

       

       

      Eventually I would like to display something similar to this: (The line graph shows the target total for each time period)

      example.PNG