6 Replies Latest reply on Feb 13, 2019 3:39 AM by sunil.balijepalli

    Hiding first column in yoy calculation

    sunil.balijepalli

      In the attached image, I do not want to see the first column

       

      First column refers the revenue in 2017 and second column refers the revenue in 2018.

       

      I do no want to hide the column manually as there are many such worksheets and looking for a fix that could be used across the sheets.

       

      There is no value for Region 6 in 2017-Q3

       

      Capture.PNG

       

      I used filter for Revenue field. Navigated to Special-->Non-non values. But the result displayed is as shown below. The revenue value in Region 6 is not visible with this approach

       

      Capture1.PNG

       

      Please let me know how could I have the revenue value for Region 6  as well. I am looking for the below result set.

       

      Capture2.PNG

       

      Also, if there is time-index parameter that is set in database and years get automatically changed after a specific quarter, is there an automatic approach to hide the previous year automatically.

       

      In this case when the 2018 Q4 comes and comparison is done with 2017 Q due to change of time index in the database, can the previous year be hidden automatically