Use Calculated Dimension to restrict the date

[priya945]

Hi All,

My Data is 

Value	Date	Regon
1	8/31/2018	N
1	9/30/2018	S
1	10/31/2018	N
0	11/30/2018	S
1	12/31/2018	N
0	1/31/2019	S
1	2/28/2019	N
0	3/31/2019	S
1	4/30/2019	N
0	5/31/2019	S

Expected output in pivot table. My requirement is to restrict the Date  for last 2 dates using the calculated dimension  . Please suggest

	Region	N	S
	Date	4/30/2019	5/31/2019	4/30/2019	5/31/2019
Value		1	0	0	0

Thanks in advance.

[StarinieriG · Accepted solution]

Hi,

maybe use something like this

=Aggr(If(Rank(Date)<=2,Date),Date)