11 Replies Latest reply: Nov 17, 2011 10:14 AM by rizo98 RSS

    Conditional aggr expression

    rizo98

      Hello guys,

       

      I am trying to do a conditional aggr function but failing.

      I am trying to filter on salesman_id to find out what days he has worked.

      I then wan to calculate the total sales by all salesman for that day.

       

      e.g. in the attached spreadsheet, salesman Id 2005 has worked days 1,4,7,9 etc

      I remove the filter from salesman ID and put the filter on day 1.

      I then get the total of List Price for day one which is 90483.

       

      I am struggling to put this in my expression, please help

      thanks