Could you please guide me on calculating MOM,YOY,Monthly GAP in the pivot table???
Region | country | Date | Values |
NA | US | 12/1/2017 | 100 |
NA | US | 13/2/2017 | 200 |
NA | US | 14/3/2017 | 300 |
NA | US | 5/4/2017 | 400 |
NA | US | 11/5/2017 | 500 |
NA | US | 20/6/2017 | 600 |
NA | US | 23/7/2017 | 700 |
NA | US | 25/8/2017 | 800 |
NA | US | 19/9/2017 | 900 |
NA | US | 19/10/2017 | 1000 |
NA | US | 15/11/2017 | 1100 |
NA | US | 17/12/2017 | 1200 |
NA | US | 10/1/2018 | 1300 |
NA | US | 11/2/2018 | 1400 |
LAM | Argentina | 12/1/2017 | 1500 |
LAM | Argentina | 13/2/2017 | 1600 |
LAM | Argentina | 14/3/2017 | 1700 |
LAM | Argentina | 5/4/2017 | 1800 |
LAM | Argentina | 11/5/2017 | 1900 |
LAM | Argentina | 20/6/2017 | 2000 |
LAM | Argentina | 23/7/2017 | 2100 |
LAM | Argentina | 25/8/2017 | 2200 |
LAM | Argentina | 19/9/2017 | 2300 |
LAM | Argentina | 19/10/2017 | 2400 |
LAM | Argentina | 15/11/2017 | 2500 |
LAM | Argentina | 17/12/2017 | 2600 |
LAM | Argentina | 10/1/2018 | 2700 |
LAM | Argentina | 11/2/2018 | 2800 |