1 of 1 people found this helpful
It will not calculate the correct total because by using a table calculation (index()), the full set of data is used before hiding some of it.
But why do you use it like that? Why can you not just filter object on "Fact" ?
Hope that helps,
What if I want to do what Andrey did? I want my subtotals to calculate on the entire data set regardless of the "N" items I am subtotaling.