Firstsortvalue on a Dinamic Table

[#1]

Hello Experts,

I need a function similar to Firstsortvalue() does in Script, for to put on a Dimension or Expression Dinamic table. like this example

My data are

Field 1 | Field 2

1 | A

1 | B

2 | D

2 | C

And I Want the result on a Dinamic Table:

Field 1 | Field 2

1 | A

2 | D

Just the first Field 2 data for Field 1

Is it Possible?

Tks Experts

[spividori]

Hi.

In the scripts you can use

Table1:

Load Field1 as FirstValue1,

Field2 as FirstValue2,

if(Field1=previous(Field1),0,1) as Check

resident Table

oreder by Field1;

And then select the records where the Check is 1.

Regards.

[pover]

You can also try the following:

Table1:

Load rowno() as Order,

Field1,

Field2

resident Table

and then the expression would be firstsortedvalue(Field2,Order).

There's also a firstvalue() function for the script that you would use with a Group by Field1.

Regards.

[#4]

Ok, But is it possible do this on an expression into a Dinamic table? or on a Dimension Calculated?

[#5 · Accepted solution]

TKS Experts I using the function Maxstring()

Its Ok