i have a requirement for user and date

[saumyashah90]

User	Date	Value
U1	14/12/2014	11
U1	24/12/2014	3
U2	13/11/2014	4
U3	3/12/2014	3
U3	4/12/2014	2
U3	27/12/2014	11

I need out put with each users max date and its value

U1  24/12/2014   3

U2  13/11/2014    4

U3   27/12/2014   11

Thanks

[sunny_talwar]

Where are you trying to show this? in a straight table or text box?

[settu_periasamy]

Hi,

Try this

Load User,Max(Date),Sum(Value) Resident YourTable Group by User;

[eduardo_sommer]

Use a straight table with User as dimension and two expressions

For the Date Column: firstsortedvalue(Date, -Date)

For the Value Columnd: firstsortedvalue(Value, -Date)

The -Date in the function is to reverse sorting

Eduardo

[sunny_talwar · Accepted solution]

[saumyashah90]

Hi sunny,

i got date corretly but not value.

Basically Value is already count of (Dates) which no. of times that user have used it on that day

so values= Count(Dates)

and when put FirstSortedValue(Count(Date),-Date)

it shows me error

[saumyashah90]

i guess normal count(Date) will work

[MayilVahanan]

Hi

May be try like this

Load User, Date from yourtable;

Join

Load User, Date(Max(Date)) as maxDate Resident Table1 Group By User;

In Straight table

Use

User and maxDate as Dimension

Exp:

= Sum({<Date = {"=Date=maxDate"}>} 1)