Loading

Show Fixed Rank of a Measure When Using a Filter

Date de publication: May 8, 2025
Tâche

How to get a fixed rank with a filter in a cross table. which means if the filter narrows the data showing in the table, the rank should be as same as the rank with the whole table.
User-added image    User-added image

Étapes
Create a calculation field to replace the [Region] field in [Filter] shelf.

The calculation is as below:
LOOKUP(ATTR([Region]),0)

User-added image

Please see the attached workbook.
Numéro d’article de la base de connaissances

001453848

Pièces jointes

Fixed Rank_v2018.1.twbx

1159 KB

 
Chargement
Salesforce Help | Article