This content has been marked as final. Show 1 reply
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.