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

    Conditional aggr expression


      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