Firstsorted value issue

[gauthamchilled]

When i change the period sort filter, the text box not showing the previous value

attached example

can any one help?

[gauthamchilled]

Bump

[tresesco]

If it is related to: Current Vs PRevious

Try :

=Max({<Period_Sort={"<$(=Max(Period_Sort))"}>}Period_Sort)

[jyothish8807]

Hi Tresesesco,

Nice solution , can you please help me to understand how it takes only the previous value ?

If i make it  '>' it always takes the max value .

Br,

KC

[jyothish8807]

Hi Gautha,

One more approach.

Load * inline

[

Period_Sort, Order

20171, 1

20172, 2

20181, 3

20182, 4

]

Create a variable :

Var=concat( {1}chr(39)&Period_Sort&chr(39),',')

In text box:

=pick(MaxString({$<Order=>}Order)-1,$(Var))

Br,

KC

[shreya_nadkarni]

superb solution!

[tresesco]

Period_Sort={"<$(=Max(Period_Sort))"} - gives all values less than the maximum (in scope). Therefore, if you select 20181, the possible values to Max() would be 20171, 20172, and max() would then return 20172 which is second to the selected one/max in the scope.

[jyothish8807]

Nice , Thanks for the explanation.

Br,

KC