How can I fix below problem?

[#1]

Dear Experts,

example -

in Year 2009, I have 4 quarter - Q1,Q2,Q3 and Q4.

When I collapse 2009 then I want to show all the time last quarter value, Q4 - 92.43.

In expression I used Max(amount) it returns the max Quarter value when I collapse.it shows - Q2 - 207.74.

Please give me solution.

Thanks

saifur

[MK_QSL]

can you share your sample file or apps?

[#3]

Please see the attached file.

I need to show last quarter value when collapse.

[Nicole-Smith · Accepted solution]

Change your expression to:

FirstSortedValue(fabs(RRE_BSAllData.RRE_FocusAmount),-Date)

[#5]

Hi Nicole,

Thanks for giving me the solution.It works.

Thanks

saifur