Straight table

[#1]

I have to have 4 columns...

Lease Name     Building Code          BU                     Exp                       Rsf

123                   ABC                      WH                    12/12/2020             20,000

456                   ABC                      OFFICE              12/6/2016              30,000

789                   ABC                      DC                     12/7/2018                6,000

I want to display 1 row on Building Code and max of Exp and sum(Rsf)

O/p

Building Code                 BU             Exp                     Rsf

ABC                              WH            12/12/20120          56,000

How can I do this ?

Thank you.

[satishkurra]

PFA

[Gysbert_Wassenaar · Accepted solution]

Dimension:

• Building Code

Expressions:

• BU: FirstSortedValue(BU,-Exp)
• Exp: Max(Exp)
• Rfs: sum(Rsf)

[awhitfield]

You may need to format the exp value as a date though.

HTH

Andy

[satishkurra]

PFA

[#6]

I need the BU based on the exp date as well

[#7]

FirstSortedValue(BU),this gives me error !

[Kushal_Chawda]

see this

[Chanty4u]

U can try,

=FirstStoredValue(Bu,-Exp)    //   here "-"  negative symbol gives u the sort order with highest value.

=FirstStoredValue(Exp,-Exp)

=sum(Rsf)

[sunny_talwar]

Did you miss the -Exp Pavana?

Look closely at what Gysbert suggested