calcultation in structure with hierarchy

[Former Member]

Hello,

I have a report, which its columns are structure and under it there is an InfoObject with hierarchy. I also chose to display the columns as a hierarchy so every column in the structure appears in the report as a hierarchy of the InfoObject.

I want to do a percentage calculation between two columns of the structure: In the first columns I want to use the top of the hierarchy and in the other column I want to use the hierarchy level. Is there a way to use a column in the report without its hierarchy?

Hope I’m clear.

Please Advice

Amir

[Former Member]

I know its a bit complecated but still,

Can someone please help me?

[Former Member]

<i>I want to do a percentage calculation between two columns of the structure: In the first columns I want to use the top of the hierarchy and in the other column I want to use the hierarchy level</i>

Can you give an example..as this is difficult to understand..

Ashish..

[Former Member]

For Example I want to calculate the percentage of one column from the sum of all the other columns. when I open the hierarchy of the calculated percentage column i get the ratio between the leaf of the hierarchy in all columns that i want to calculate (the ratio i get is between the leafs <b>in the same level</b>) but my user wants the ratio between the total sum (which is in the root of the hierarchy) to every leaf in the hierarchy.

Is there a way to suppress the hierarchy just in one column?

Hope I’m clearer now.

Thank you for your help!

Amir

Message was edited by: Amir Dror