RE:Default selection

[Chanty4u]

Hi all ,

I have small issue  .  i hve data like below

296.81

REQ:

Output:  Witouht selection the result should be earliest month value  :

Result   1/4/2015  =621      it should be reflect for only sum(opening balance) 

[sunny_talwar]

There are two reference No for 1/4/2015, you want to see both or just 1? How do you choose 40170162260? Also does the table need to change once you make the selections?

[Chanty4u]

opening balance should be  reflect..

1)when you select 1/4/2015   the value is sum(openg)=621

so the sam evalue should be displayed without any selections.   [i.e: it should not be summed]

for 1/4/2015  -ref num  478761772

[Clever_Anjos · Accepted solution]

Please try

FirstSortedValue([Running Balance], [Value Date] )

[Chanty4u]

Thnx clever .  i will try and let you know

[sunny_talwar]

ref number  478761772 has a running balance of 71.81? I am not sure what you want? May be this:

FirstSortedValue({<[Reference No] = {40170162260}>}[Running Balance], [Value Date])

[Chanty4u]

thanks sunny its working.. let you know   after checking with original data.

[sunny_talwar]

Sounds good

[Chanty4u]

thanks clever .Its working fine.

Thanks stalwar1 ur solution is also correct but not dynamic .