Sales Data for max Date

[turodionova]

Hi!

I need to create report with sales data by customers related to the latest sales date for each.

Yellow lines in the table below are what i need to extract.

I use an expression: aggr(max(Date),[Customer]) and get right date for every Customer.

Then i try to use this expression for sales data: sum({$<Date={"=aggr(max(Date),[Customer])"}>}Sales) 

and get a wrong result.

Thanks in advance.

[MK_QSL]

FirstSortedValue(Sales,-Date)

[Agis-Kalogiannis]

Was it exactly what you were looking for Tamara? Did it work?

[turodionova]

Hi, Agis!

It does not work unfortunately in my case. I guess some grouping is

needed?

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)

[MK_QSL]

Provide few more data which showing that this is not working.... This should work on the sample data you have provided.

[turodionova]

Sales - ,

Date - Дата

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)

[ecolomer]

here you have an example for this

[MK_QSL]

Can you create little dummy data and pass to us? Your application is difficult to understand..

[turodionova]

Manish, your expression works in a model with dummy data, so the issue is

in my application.

I will try to identify, thanks for your help.

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)

[turodionova]

Manish, it worked, but as soon as i concatenate additional value, it

stopped working.

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)