Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.
Here is the example table and expected pivot table results
Region
Product
Source
Industry
FEE
Bank Name
Year
India
P1
A
L1
80
BOA
2023
India
P1
A
L2
88
City
2023
India
P2
B
L1
23
SriBank
2023
India
P2
B
L2
36
HDFC
2023
USA
P1
A
L1
28
BOA
2023
USA
P1
A
L2
51
City
2023
USA
P2
B
L1
87
SriBank
2023
USA
P2
B
L2
26
HDFC
2023
India
P1
A
L1
20
BOA
2024
India
P1
A
L2
23
City
2024
India
P1
A
L2
43
SriBank
2024
India
P2
B
L2
18
HDFC
2024
India
P2
B
L2
68
SriBank
2024
USA
P1
A
L1
30
BOA
2024
USA
P1
A
L2
35
City
2024
USA
P2
B
L1
44
SriBank
2024
USA
P2
B
L2
95
HDFC
2024
In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions. Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns.
