4 Replies Latest reply on Apr 6, 2015 3:32 PM by Andrew Mendoza

    Hidden data does not stay hidden in a hierarchy?

    .Yann Treguier

      I have a two levels hierarchy.  Group--Region. After expanding the hierarchy, I decided to hide some of the regions which are irrelevant.  Problem is: once I collapse the hierarchy and expand it again, the previously hidden fields are back into view....Even if I create a calculated field that only show the regions I want, the ones I don't want will show as NULL or "Other" if I name it, but I still won't be able to hide that bucket in the table.

       

      I cannot filter out the regions to be hidden as their assigned values need to be computed in the table grand total. Any suggestions?