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


      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.