Hi,
I have this pivot table with ranked values of 1Yr and 5 Yr returns of various funds. I am trying to create a calculated field column with 50%*Rank1Y + 50% Rank 5Y. However, the calculated field doesn't let you choose the ranked values as the base for the formula. I was wondering if there is a way to achieve that result.
One workaround is that I could rank it in the original table itself and then create the calculated field, however, I want the flexibility to be able to dynamically change the category for the ranking which works when using slicers but would not work with ranking directly in the table.
Would appreciate any solutions to this, thanks.
I have this pivot table with ranked values of 1Yr and 5 Yr returns of various funds. I am trying to create a calculated field column with 50%*Rank1Y + 50% Rank 5Y. However, the calculated field doesn't let you choose the ranked values as the base for the formula. I was wondering if there is a way to achieve that result.
One workaround is that I could rank it in the original table itself and then create the calculated field, however, I want the flexibility to be able to dynamically change the category for the ranking which works when using slicers but would not work with ranking directly in the table.
Would appreciate any solutions to this, thanks.
