I'm really struggling in grasping the hierarchy functionalities.
I have generated a hierarchy function to build a hierarchy tree of some points of measure.
Each node of the hierarchy measures a certain value. The father's node value is not necesseraly the sum of it's childs.
for this reason what i would need is to display only the value of the father when I make a selection on it.
Currently I have this situation:
when I make a selection on a node of the tree what happens is this:
the visusalization works correctly, but the data shown takes into consideration the sum of the selected node (wich has already the value i would like to display ) with the value of his children nodes, as you can see in the table on the right there are 3 nodes selected.
This happens probably because the tree is built using as nodes the pivot fields built by the hierarchy function (ex. [Descr device1], [Descr device2], [Descr device3]...), infact if I use a box filter using the original dimension [Descr device], this happens:
Only the single node is selected and not the hole tree, thus displaying the data only relative to the single node and not his child. The visualization does not show the children, and it's ok like that.
And hear my question is there a way to obtain the same result of the second situation by selecting directly on the visualization?
If I select for example [Descr device2] coul it actually select only the corresponding [Descr device]?
Should i probably define the dimension in the visualization if possible something like:
if([Descr device]=[Descr device1], [Descrdevice]) for each level of the tree?