Set Expression and Calculated Dimension

[Ram83]

Hi,

I need Repeated Customers Analysis, how to write the Calculated Dimension for Only last visited Sales .

for Example,

In below mentioned table, Rank 3 is last visited sales.So, in Calculated Dimension I want display Rank 3 Record only.

Rank	DocNum	DocDate	CountyB	Brand	Segment	Sales
1	1911100895	07-05-19	6374860082	PREETHI	MIXE	3100
2	1911100943	08-05-19	6374860082	CROMPTON	AIRCOOLER	5099.99
2	1911100943	08-05-19	6374860082	VENUS	FAN	1000
3	1911101297	21-05-19	6374860082	CROMPTON	ACCESSORIES	390.01

I have written this Expression

=Aggr(if(Rank(Total Sum(LineTotal_WithTax))/Count(distinct{<CustPhoneNo = {"=Rank(Total count(distinct DocDate))=2"}>}CustPhoneNo),'2 Times'),CustPhoneNo)

its not working.

Anybody please help me. how to write the set expression and Calculated Dimension.

[sunny_talwar]

Rank is not a field here?

[Ram83]

Rank is not a field, that is the Rank function.

[rkpatelqlikview]

Hi Ram,

Did you try with Forstsortedvalue() in the expression? Is  Last visited determine with DocDate? If yes, i think we can achieve this with firstsortedvalue.