Hi Everyone,
I have to add column Total for 2019 and 2018(like shown in table below), Not sure how this is done in the below scenario -
Name | Calculated Fields | 2019 Total | 2018 Total | 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 with new calculate column, Could someone please advise the best way.
Thanks in Advance!