Re: Problems with calculated dimension and hierarchy
If the total is a calculated field of lines 1 and 2 that are below the group. However this total is being applied on all lines and should be applied only in the total group is the level 1 of the hierarchy.
The figure below is the result that accurate, the calculated field where the group size is just the sum of the line 1 and 2 which is a dimension subgroup.
Recapping I have two two dimensions and a sublevel and the other. I am Group size and subgroup size that are children Group.
However the calculation that I am using is calculating correctly but is changing the value of all subgroup of the items below as is the image you insert in the previous post.