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


        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
      D 7
      E 1