1 Reply Latest reply on Nov 29, 2017 9:03 AM by Deepak Rai

    Filter Secondary datasource for blending

    Brian Fornelius

      Hi there...

       

      I am trying to do some benchmark data but want to remove the customer I'm reporting on from the overall benchmark data.

       

      I'm doing this by connection to the same database twice.

       

      The first one (the ones the worksheets is based of us) is the Company (Company A) data that I'm wanting to show.

      The second contains data from (All Customers) where I'm just pulling in a sales average.

       

      What I want to do is remove (Company A) from the list of (All Customers) so that their own data doesn't factor into the benchmark Sales average.

       

      Thanks,

      --Brian