Date change to Day (Numerical) in Pivot

[shansakhi]

Dear All,
How you all are fine and doing well.
I have a query about Pivot.
I have a huge date level data and based on the same I am creating pivots. Now I would like to compare MTD performance v/s last year. For example 01May-14May 2018 Revenue v/s 01May-14May 2017 Revenue.
In pivot if I consider data at date level its gives me below table which I am unable to compare between 2018 and 2017.

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"] [TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[/TR]
[TR]
[TD]1-May-2017[/TD]
[TD]1000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2-May-2017[/TD]
[TD]1500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3-May-2017[/TD]
[TD]700[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1-May-2018[/TD]
[TD][/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]2-May-2018[/TD]
[TD][/TD]
[TD]1400[/TD]
[/TR]
[TR]
[TD]3-May-2018[/TD]
[TD][/TD]
[TD]900[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

Is there any possibility that I can have data as below in pivot. I WILL NOT ABLE TO MAKE ANY CHANGE IN BASE DATA AS ITS VERY HUGE AND IN ACCESS.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]2018[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1000[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1500[/TD]
[TD]1400[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]700[/TD]
[TD]900[/TD]
[/TR]
</tbody>[/TABLE]

Regards,
Shan