Displaying the data associated with the Max value only in a chart

[hobanwashburne]

I have a basic chart the dimensions being

Part Number/Customer

and the Expression

Max(InvoiceDate)

That currently returns data such as

Row / PartNumber / Customer / InvoiceDate

1         A                    1                 3/8/16

2         B                    2                 4/6/16

3         B                    3                 4/8/16

4         C                    4                 4/5/16

I would like to discard row 2 so that each part number is only displayed once regardless of the customer. Is this possible?

[gajapathy74]

Instead of Max(InvoiceDate), can you try Aggr(Max(InvoiceDate), PartNumber)

[hobanwashburne]

Close, however now the chart is displaying:

PartNumber / Customer / InvoiceDate

B                     2                4/8/16

Which is concerning because although the max invoice date is 4/8/16 it is not for customer #2

[sunny_talwar]

May be use this

Dimension:

PartNumber

Expressions:

FirstSortedValue(Customer, -InvoiceDate)

Max(InvoiceDate)

[sunny_talwar · Accepted solution]

or you can try this:

Dimension

PartNumber

Aggr(FirstSortedValue(Customer, -InvoiceDate), PartNumber) *

* Select 'Suppress When Value Is Null' for this dimension

Expression

Max(InvoiceDate)