5 Replies Latest reply on Nov 6, 2017 7:21 PM by Deepak Rai

    On the Fly Calculations based on Date Filter

    Sandesh Ashok Naik

      Hi All,

       

      I have the below requirement.

       

      The users will select a Date Range based on the Date field. If anyone of the sales in that Date range for an employee is greater than 500 I want to display as 'Y' else 'N'.

       

      EmpCampaign
      DateSalesCalculated field
      1ABC08/10100Y
      1EFG08/11600Y
      1HIJ08/12250Y
      2LMN08/11700Y
      2OPQ08/12800Y
      3RST08/1130N
      4UVW08/125N

       

      I tried using WINDOW_MAX(Max(sales)) but the function returns that maximum sales for all the days.  I need this to break by Emp>Camapign. If I use LOD 'Fixed', the function takes into account the Max(commission) for all the values in the table.

      Can someone please help.

      I've attached a sample workbook.