I have a crosstable with the column World Bank Country as Vertical Axis and a Ranking column as cell values(Column names for horizontal).
The Ranking column is built with this custom expression :
First(DenseRank(Sum([Weighted NormalizedValue]) OVER ([World Bank Country]),"desc"))
I get this error : When the visualization contains a categorical axis that is evaluated on the current filtering only,all over expressions on continuos axes must be placed after the THEN keyword.
I'm not able to have a right expression using THEN.Any suggestion?