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.