TREE VIEW in a PIVOT?

[#1]

Hi there

I created an hierarchy table with a PATH field, and now I want to use it as a dimention in a pivot table.

when I use a list box it workes well.

how sould I do it in a pivot?

I couldnt find any example here in the search

Thanks!

[googel84]

Hi AnatStak, if you used the HIERARCHY statement, you should have some field named NodeNameX, where X goes from 1 to the depth of your hierarchy tree.

The solution is to set these fields as dimensions of your pivot, putting them in the correct order.

Alberto

[#3]

HI Alberto

Thank you for your reply

I tried looking at the table tahat was created.

it was created with three node fields, and that makes sense, for my data.

But when I present those fields, the third one is empty and the other level look pretty strange.

in cases where there is just one level - i gate the first level correctly.

in some cases the first level is the same as the NodeName and other cases the first level is the same as the ParentName.

I cant figure this up..

Have any ideas?

[googel84]

Could you, please, provide me with your qvw? It would be easier to me to "look inside your problem"!

[suniljain]

you have to maintain level at script level.

like level1,level2,level3 by applying flag.

without it . it is not possible to display in hierarchical manner in pivot table.

[jmialoundama]

Hi everyone, 

I allow myself to revive the subject because I have the same problem today in my PivotTable.

In my pivot table I don't see all the levels.

Ashishpalkar did you manage to display your hierarchy in the dynmic crosstab?

Suniljain specified that it was necessary to indicate an indacateur. What do you mean by that ?

Thank you in advance.