find Min Date1 greater than Date2 in set analysis

[wanyunyang]

I have a customer table with Customer and UpdateDate,

another sales table with Customer, SalesDate and Amout.

I would like to see the first Sales Amount after each customer updates. So For each customer, I need to find the minimum SalesDate greater than the UpdateDate, then sum up Amount on that SalesDate. 

I'm not sure how to write the expression. Should be something like:

sum( {<Min(SalesDate)={"=SalesDate>=UpdateDate"}>} Amount)

[KishoreSuri]

Hi Wanyunyang,

Similar to your query I too have , but small difference in it.

Actually, we have a Bar chart with Customers(Dim) and exp(Sum(amt)) with Top  10 customers selection. But for the same bar chart, we want to check Min and Max range with another expression based on customers.

If we enter the range of values (Min or Max), Customers would change in the bar chart.

Here we want to use two different expressions , one is for bar chart and another for range values in input box.

Please help me out.

Thanks,

Kishore S