2 Replies Latest reply on Jul 12, 2018 8:01 AM by Tarek Elduzdar

    How to add a one column only for 6M Rolling while still showing the last 3 Months cloumns

    Tarek Elduzdar



      I am having a worksheet where i have a table showing the performance for the last 3 Months "As shown in the attached file".


      What i am looking for is :  Add a one column only for calculating the Last 6M rolling performance, Only according to the latest month (In this case SEP-17).


      tried several ways but the Last 6M column keeps calculating for each month and so i end up with 6 Columns ( 3 for current performance and 3 columns for Last 6M). Any support would be much appreciated.