Contracted Table

[Anonymous]

Hy, I have a table:

Month    Day     Value

1            1           12

1            2           23

1            3           15

1            4           20

1            5           30

When I Contracted the field day the values are add, for example:

Month       Value

1     +        100

All the values are add.

When I contracted the table, I want to pick the last value only, for example:

Month    Value

1            30

Can you help me??

Thanks a lot.

[maxgro]

a:

load * inline [

Month ,   Day,     Value

1      ,      1,           12

1       ,     2 ,          23

1        ,    3  ,         15

1         ,   4   ,        20

1          ,  5    ,       30

2       ,     2 ,          23

2         ,   4   ,        20

2        ,    3  ,         15

];

if(Dimensionality()=2,sum(Value), subfield(concat(Value, '@', -Day),'@',1))

[Clever_Anjos · Accepted solution]

Veja se atende

=if(Dimensionality()=4,sum(SALDOFISFINAL),sum({<DIA={"$(=MAX(DIA))"}>}SALDOFISFINAL))

[Anonymous]

Funcionou, muito obrigado.