Replace Keyfigures on certain characteristics with a formula?
i have an info cube with 2 keyfigures: cost1 and cost2 and two characteristics: wbs-element and company code.
My goal is to create a query which shows me wbs-element and one keyfigure. If the characteristic company code is '100' i want to use the keyfigure cost 1 if the company code is '200' i want to use the keyfigure cost2.
Is it possible to create such a query? Which a formula i only can create three colums. Or is there a other way?