5 Replies Latest reply on Jan 27, 2016 10:38 AM by Suk Lee

    Total Value that is not affected by filters

    Stuart Hill

      I am really struggling to define a total sales measure in the attached workbook that remains unaffected by the Profit filter.  I want to show the count of orders in profit per day and the total count of orders for that day to illustrate the comparative difference.  The attached file is just to simulate the problem, the real workbook is using a large extract so I want to avoid blending with a duplicate extract.

       

      Any help gratefully received.

      Cheers, Stu