Hi Everyone,
I have to add column YTD for 2019 and 2018(like shown in table below), Not sure how this is done in the below scenario -
| Name | Calculated Fields | 2019 YTD | 2018 YTD | MAR-2019 | FEB-2019 | Jan-2019 | Dec-2018 | Nov-2018 | Aug-2018 | Mar-2018 | Jan-2018 |
| Name1 | Internal | 2 | 10 | 1 | 1 | - | 2 | 2 | 2 | 2 | 2 |
| | External | 4 | 8 | 2 | 2 | - | 4 | 4 | - | - | - |
| | Legal | 6 | 15 | 3 | - | 3 | 5 | 5 | 5 | - | - |
| | Item | 1 | 2 | - | 1 | - | 2 | - | - | - | - |
| Name2 | Internal | | | | | | | | | | |
| | External | | | | | | | | | | |
| | Legal | | | | | | | | | | |
| | Item | | | | | | | | | | |
I want to create for such scenario, Could someone please advise the best way.
Thanks in Advance!
