How to find last 3 Sales of the customer when entering the Customer ID

[rkpatelqlikview]

Hi All,

Can anyone help on this?

How to find last 3 sales of the customer once i enter the customer id?

Example: Entered Customer Id is A202.

I need last his sales

100+200+300 =700.

How to solve this? Thanks in advance

Date	Sales	customer ID
27.10.2017	200	A202
30.10.2017	633	A202
02.10.2017	100	A202
06.10.2017	200	A202
25.11.2017	300	A202

[sunny_talwar · Accepted solution]

When you say entered, do you mean when you select a particular customer id?

May be this:

Sum({<Date = {"$(='>=' & Date(Max(Date, 3), 'DD.MM.YYYY'))"}>}Sales)

[rkpatelqlikview]

Thanks Sunny