2 Replies Latest reply on Sep 24, 2018 11:46 AM by Kamil Nikiel

    Sum only "X" amount of rows in hierarchy/ Grand totals not match when filtered

    Kamil Nikiel

      Hi,

        I got a table like this, when I expand hierarchy:

       

      The issue I got is that I have created a hierarchy for Dimensions, and filtered out rows "D" and "E" and cannot get hierarchy grand totals to match, when I wrap up hierarchy sum for "Value 4" is 30 not 22.. Any ideas how to solve it?

       

       

      DimensionValue 1Value 2Value  3Value 4
      A189115
      B255228
      C322669
      D 7
      E 1