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