get the amount of the max line number

[ali_hijazi]

Hello

I got a table that contains the ItemID, TransactionNo., and the StockAmount

on a specific date I may have the following data

ItemID     TransactionNo     StockAmount

27          13397068          5820.72

27          13389275          5849.45

27          13377953          5839.65

now I want to display on a pivot table the ItemId the maximum transactionNo. along with the related stockAmount

I put as dimension the ItemID

now the expressions are Expression1 and Expression2

Expression1 = Max(TransactionNo) and I get 13397068

Expression2 = StockAmount but I get -

what shall I do

Please advise

[its_anandrjs]

Hi,

You want to display only Max transaction no Details please clear it.

Regards,

Anand

[ali_hijazi]

I want to display the expressions 1 and 2

what is the thing that is not clear?

[its_anandrjs]

Hi,

Ok means

1. 13397068

2. 5820.72

Regards,

Anand

[ali_hijazi]

exactly

[Sokkorn]

Hi Ali,

For the second expression use this : SUM({<[TransactionNo]={$(=Max([TransactionNo]))}>}[StockAmount])

Check more on attached file.

Regards,

Sokkorn

[its_anandrjs]

Hi,

See the attached i think you need to use some thing like this.

Regards,

Anand

[ali_hijazi]

still getting -

[Sokkorn]

Hi Ali,

Did you check my attached file?

Regards,

Sokkorn

[ali_hijazi]

when I use sum({<TransactionNo={$(=max(TransactionNo))}>}StockAmount) I'm getting the maximum amount without taking into consideration the dimension!!!