show selected dimension

[jduluc12]

Hi,

My data set looks like this

Cust      date         amount

a            01/02/2017     10

b            02/06/2017      20

c            06/17/2017      40

d            05/17/2017      30

I need to write a dimension which shows the customer only when today-date <= 30.

that means if today is 7/17/2017 then only 'c' should appear with its amount.

[#2]

1:
load * Inline [

Cust , date , amount,A

a , 01/02/2017 , 10

b, 02/06/2017 , 20

c, 06/17/2017 , 40

d , 05/17/2017 , 30

];

load
Cust,
Today()-date(date#(date,'MM/DD/YYYY'),'DD/MM/YYYY') AS DIFFERENCE,
date(date#(date,'MM/DD/YYYY'),'DD/MM/YYYY') AS date,
amount
Resident 1;
drop Table 1;

AND  

use calculated dimendion in chart like this 

=IF(DIFFERENCE <=31,Cust)

sum(amount) as expression

[prma7799]

Like this ???