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.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
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.
<tbody>
</tbody>
Regards,
Shan
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.
<tbody> </tbody> |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
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.
| Date | 2017 | 2018 |
| 1 | 1000 | 1200 |
| 2 | 1500 | 1400 |
| 3 | 700 | 900 |
<tbody>
</tbody>
Regards,
Shan
