Automatic aggregation along a hierarchy

[Anonymous]

Hello,

I've made a hierarchy in order to see a geographical dimension as a tree. I would like that if a user clicks on a node, he sees the total amount of all the underneath nodes.

In the example attached, if I clik on 'France' in the selection list, it's OK I get the lines for France, but if I clik on 'France' in the tree, I can't see anything.

Is there a solution by using Hierarchy or HierarchyBeslongsTo ?

Thanks in advance

Thierry

[jvitantonio]

If you go to your table and check the data , you'll see that for field Chemin when the  value is Portugal, Espagne or France you have no values assign in Pays, so this will select nothing. You either add the country there or you set analysis in your expressions.

[Anonymous]

Do you mean the solution is to calculate in the script the aggregation for the nodes above the lowest nodes ?