Load max hour

[sanjujeeboy]

Hi 

i have a table like shown below: my requirement is in the chart i should get max date and max hour data ie 11/8/2019 and 3rd hour sales ie 108. how to write expression for this?

Country	Date	Hour	Sales
germany	11/6/2019	1	100
germany	11/6/2019	2	101
germany	11/6/2019	3	102
germany	11/7/2019	1	103
germany	11/7/2019	2	104
germany	11/7/2019	3	105
germany	11/8/2019	1	106
germany	11/8/2019	2	107
germany	11/8/2019	3	108

[sanjujeeboy]

sorry the correct table is

Country	Date	Hour	Sales
germany	11/6/2019	1	100
germany	11/6/2019	2	101
germany	11/6/2019	3	102
germany	11/6/2019	4	103
germany	11/7/2019	1	103
germany	11/7/2019	2	104
germany	11/7/2019	3	105
germany	11/8/2019	1	106
germany	11/8/2019	2	107
germany	11/8/2019	3	108

[tresB · Accepted solution]

Try like:

Dim 1: Country

Exp 1: Date(Max(Date))

Exp 2: FirstSortedValue(Hour, -(Date*24+Hour))

Exp 3: FirstSortedValue(Sales, -(Date*24+Hour))

[sanjujeeboy]

Hi 

i want the output in straight table as 

Country	Date	Hour	Sales
germany	11/8/2019	3	108

[tresB]

Did you try the solution I proposed?

[sanjujeeboy]

Spoiler

Hi,

the solution does work. Thanks

can we write a set expression for this? 

[tresB]

Set analysis is not something that should be used everywhere. Here you don't need that. 

Please close the thread by giving 'like' and/or marking 'correct answer'.