2 Replies Latest reply on Oct 26, 2018 9:31 AM by Elizabeth Atkins

    Is it possible to keep percentile rank static when filter applied?

    Elizabeth Atkins

      I am trying to create a dashboard that would only show one measure at a time out of all measures used in a sheet.

      Currently, when I do not apply the filter of selecting a program, the percentile rank table calculation is correct because it is being calculated using all programs:

      However, what I created this sheet for was to use in a dashboard to feature only one program at a time, but since the filter is now applied, the percentile rank goes to 100 since it is the only program the table calculation is using:

       

      How can I keep the percentile ranks static so that when I select one program, the percentile rank is still being calculated using all programs?

      ie the single view would be:

       

      Any ideas would be appreciated!