Date in set expression - pivot table

[CuriousGeorge]

Hi, I want to be able to use year/quarter/month in a set expression to display a column field. 

if it is on Aug-2021, then display $10,000 for instance. 

How can I make it work? 

If(Year(CreatedDate) = '2021' 
	and 'Q' & ceil(month(CreatedDate)/3) = 'Q3'
	and Month(CreatedDate) = 'Aug', 10000, '')

[CuriousGeorge · Accepted solution]

I solve my own issues, just insert if else statement on load script and use it on my set expression. I would still eager to know how we can use year/quarter/month (pivot table) on a set expression (if anyone has any idea)