Sum in Hierarchy - have to close tree, can't use Set Analysis

[#1]

I am using "Load Hierarchy" to load a tree and data and I want to calculate the sum on certain tree-positions.

I can select a tree position in a list box using tree view and calculate the sum in a pivot.

As long as I do not expand the tree I can read the values, but when I expand the psotion and select "operating profit" againg then there are no values.

The problem is we cannot always close the tree to see the value but we want to select the fields also in an already expanded  tree.

The other problem is I cannot use Set Analysis Expressions to select this Field (oerating profit) für calculating the sum on the values. How it is possible to calculate the sum on perating profit without using the hierarchy-levels (childname1 to 😎 because they change sometimes. I would like to use the child in the set analyses.

[#2]

is nobody working with the hierarchies

[SunilChauhan]

use

ParentID &'/'&ChildId as treeview

take in list box and seleect property of list box and check treeview and provide + as seperator

in table go to presentation and uncheck supress zero values

check  your data also weither its geetting zero or not

or else

share your excel files

thanks

Sunil Chauhan

in script instead of Hierarchy function

[SunilChauhan]

make ur dimension in correct format

[#5]

Hello Sunil,

I am not sure if I'm getting you right. I am already using a listbox with Treeview and separator, you can see it in the screenshots above.

My problem is, that I cannot see a sum when the list is expanded, I have to close the list but as the information is needed we would like to see the open list and the result.

The other problem is I cannot use set alanysis to calculate a value using the hierarchy.

attached you can find the excel file but I am not sure how it can be of any help.