6 Replies Latest reply on May 12, 2016 12:35 AM by Łukasz Majewski

    Running sum issues from a secondary data source

    victor.sirinopakul

      Hi All,

       

      I am trying to show a rate of requests/cumulative sales over time which is calculated from values from different data sources. The numerator is "Number of Requests" which is a COUNTD of Request ID Number. The denominator is "Cumulative Sales" which is a running sum of number of sales to date. Furthermore, the rate graph should be updated based on a filtered applied on the "Request type".

       

      The problem is that the running sum doesn't calculate correctly since it comes from the secondary data source (Sales) whose dates exceed the range of the primary data source (Requests). Is there any way to include the full range of data in the cumulative sum calculation?

       

      I have attached a workbook illustrating the issue.

       

      Many thanks,

       

      Victor