The last row of my table is a total row, in which I’m trying to calculate the sum of squares of the ‘Distance’ column. Since there is no ready-made button for that in the following drop menu
I tried to manually write the following ‘=SUMSQ([Distance])’, as shown in the picture below.
It appears to work correctly when no filter is active in the ‘complete_linkage’ column. As soon as I apply a filter, SUMSQ behaves very strangely and returns values greater than that when no filter was active.
I honestly have no idea how such values are calculated and how to fix the problem.
Any help is appreciated, thanks in advance.