Skip to Content
0
Former Member
Sep 22, 2008 at 12:45 PM

Replace Keyfigures on certain characteristics with a formula?

19 Views

Hello

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?