Sales from the date of sale of the goods

[kolov007]

Please help me to solve this task.

I need to calculate the amount of sales of all products for each country, starting with the first date of sale of product 1.

Germany's sales should be equal to 119, but when I see all the countries, the sales are not counted from the first date of the start of the sales of goods 1 in Germany, but from the first sales date of the goods 1 in the entire database.

[kolov007]

I try to solve this with this solution sum({<Date = {">=$(=min({<Product = {'Product 1'}>} Date))"}>} Quantity)

but it's not correct.

[Anil_Babu_Samineni]

How you are getting 119?

[kolov007]

[Anonymous]

aggr(sum({<Date = {">=$(=min({<Product = {'Product 1'}>} Date))"}>} Quantity),Region)

[kolov007]

It's not working

[Anonymous]

try this

aggr(sum({<Date = {"$(=date((Min(Date),"MM/DD/YYYY"))"},Product={"Product 1"}>} Quantity),Region)

[kolov007]

It's not working too

! !

[antoniotiman]

Hi Evgen,

like this ?

Regards,

Antonio

[effinty2112]

Hi Evgen,

Try this straight table:

Region	Sales all products from start sales of product 1
	254
Germany	119
Italy	135

The expression is:

sum(If(Date >=Aggr(NODISTINCT min({$<Product = {'Product 1'}>}Date) ,Region) ,Quantity))

Regards

Andrew