Last 3 sales dates by item per customer

[EmpireDist]

I have a straight table with expression Customer, Txn Date, and Item. I want to display only the last 3 Txn Date per item per customer. 

[Saravanan_Desingh]

Try using Rank function. If you could not, please post a sample file with expected output

[EmpireDist]

I need it to display only the last 3 sales transactions per customer per item.

[EmpireDist]

I can not get a sample file to load

[EmpireDist]

 This is a sample report. I want to display only the last 3 sales transactions for each item per customer.

[Saravanan_Desingh]

Try this,

tab1:
LOAD F1, 
     F2, 
     Date, 
     F4, 
     Num, 
     F6, 
     Name, 
     F8, 
     Item, 
     F10, 
     Qty, 
     F12, 
     [U/M], 
     F14, 
     [Sales Price], 
     F16, 
     Amount, 
     F18, 
     [Loaded Cost]
FROM
[C:\Users\sarav\Downloads\6-6-3 PAT TEST.xlsx]
(ooxml, embedded labels, table is Sheet1);

Left Join(tab1)
LOAD Name, Item, Date, AutoNumber(Name&Item&Date) As Rank
Resident tab1
Order By Name, Item, Date Desc;

[Saravanan_Desingh]

You can use any Field in the place of Date here:

 

[EmpireDist]

I still want it sorted the same way with the Customer first then sorted and grouped by item# and with the transaction dates descending. And show one column for the dates but only with the last 3 most recent dates for each transaction item per customer

[EmpireDist]

I'm still waiting for assistance on this question. I don't think Rank will work because I still want the date to display in the same column but I only want it to display the last 3 transactions dates for each item and customer.

[EmpireDist]

Do you have any more insight into this request? I need this to display only the last 3 TXNDATE per Item/Customer. I only want the date displayed in one column. I've been trying to get answers to this for way too long. I'm new to QLIK so a step by step answer would be helpful.