I would like to calculate the relative revenue (= revenue / revenue of the biggest market participant) in the BEx Query Designer. I have a key figure "revenue" and my market participant as characteristic.
I first tried to create a formula like "revenue / max(revenue)" but this doesn't work that way in Query Designer. I now tried to solve this with a calculated keyfigure but don't come to a solution.
How can I do a calculation like this in Query Designer?