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.
