9 Replies Latest reply on May 3, 2018 7:49 AM by Sreenath Raveendran

    How to use fixed in data blending

    Sreenath Raveendran

      Hello All,

       

      Im using two data source to develop the workbook. First data source looks like below. In second data source i don;t have salesrep column. Using client column to set up the relationship.

       

      SalesRep

      Client

      Order Date

      Sales

      1A4/1/20185
      1A4/2/201810
      1A4/3/201810
      1B4/6/20184
      1B4/20/201820
      1C4/15/201814
      2D4/6/201860
      2D4/14/201825
      2D4/25/201810
      2E4/10/201815
      2F4/28/201810

       

      On a sheet table, im showing the Sales Rep, Client name, their first order date, sum of sales and also have a filter added using first order date (Calculated).  First order date is calculated using the expression

       

      IF(MIN([Order Date]) > MIN([Sales].[date]))

      THEN MIN([Sales].[date])

      ELSE IFNULL(MIN([Order Date]),MIN([Sales].[date]))

      END

       

      On another sheet, im displaying a bar chart with salesrep in rows and sum of sales in columns

       

      If i apply the filter, bar chart not displaying sale rep sum with in the condition. Suppose if i select first order date filter as 4/15/2018 then table filtered correctly but chart should display the sum of client sales whose first order date >= 4/15/2018. Seems chart taking first order date within the sales rep fields and not displaying anything.

       

      Could you please someone help me to correct the bar chart to show the sum of sales.