How can i selecting the filter's layout ?

[former_member199732]

Hello,

For 0costcenter I have 2 hierarchies. In my
formula report I put a filter on 0costcenter.

When I click on the icon I have always the same hierarchy.

What is the the easiest way to select the other hierarchy ?

Is it necessary to create a new datasource ?

Regards,

Thierry Chiret

[Former Member · Accepted solution]

Hi Thierry,

You need to have two variables one Hierarchy Variables so you will select which one from 2 hierarchy you have to select and another one is Hierarchy node variable so that which exact node you want to select from previously selected hierarchy.

you can see more details to create dependency based on these variable at below link.

http://help.sap.com/saphelp_nw04/helpdata/en/83/096d399bd2046fe10000000a114084/content.htm

Regards,

Ganesh

[TammyPowlas]

As Ganesh said you can create a hierarchy variable, add that to the prompts, and then they are switchable.

See screen shot below.