1 Reply Latest reply on Jul 31, 2018 11:48 PM by Peeranut M.

    Fixed Column and compare rest of the other columns based on the parameter selection

    rajiv.mysari

      Hi All,

       

      I have a requirement which I am having challenge to achieve, I have described the problem below. Please help me on this.

       

      I am having 4 measures and each measure is shown on the table as per the parameter selection. Please refer to the image below.

       

      I would like to freeze one measure and show rest of the measure(s) as a comparison to one measure(Mission).

       

      For now, I have created two worksheets and one work sheet(left one) is kept static and the other changes as per the selected parameter value.

       

      When I apply top X ranking the rows increase and I have to scroll separately which is not what I wanted. They should be easy to compare with a fixed column on a single worksheet.

       

      Please let me know. Thanks in advance.