Show only latest product price

[#1]

How do I show only latest Product Price in a straight table:

I would like to show only the latest product price

Please assist with conditional statement or expression string for this straight table:

[sunny_talwar]

Try this expression:

=FirstSortedValue([Product Price], -[_Startdate product])

[hic]

Try

=FirstSortedValue([Product Price],-1*[_Startdate product])

HIC

[sunilkumarqv]

sonthing like this

firstsortedvalue(Product Price, stardate Product )

[#5]

Still not working, do I use Product Price as a second dimension and add that to the conditional statement?

Or do I use the above string as an expression and call it Latest Product Price?

I basically only want one value (LatestProductPrice) for BM.H.003

All the other rows should not show.

[sunny_talwar]

Use only [Product code] as dimension and this -> =FirstSortedValue([Product Price], -[_Startdate product]) as your expression.

Assuming [Product Price] and [_Startdate product] are field names from your database.

[sunny_talwar]

Check out this link for some information on FirstSortedValue: Value Associated with Min/Max Value of Another Field (Front End Solution)

HTH

Best,

Sunny

[#8]

Hi Sunny

The field names comes out ok in the expression but I get no products or max price.

[sunny_talwar]

You need to also make sure that the case of the field names also match. The expression Editor may not find a difference between PRODUCT and Product, but if the field name is Product, you cannot use PRODUCT. See if that is what is missing.

[#10]

Hi

  Load

  productcode,

  discountprice,

  max(satartdateproduct) as latestdate

resident  abc group by productcode, discountprice ;

   load this data and call these dimenssion into table box then your done with your work

thanks

Manju