I have two columns : first one for incomes et second for people. I activated the auto-filter thus I can display all incomes for a particular person. (see attached subtotal-example.ods).
My question : I tried to use the subtotal function to track the total amount of incomes for each person…but as soon as my display filter parameters change, the subtotal change :o(
Do I use the subtotal function the wrong way or simply misunderstood it ? and above all, how would you achieve this goal (total based on display filter results)
Thank you !