Subtotal function acts weird

asked 2012-10-12 23:44:25 +0200

sulliwane
31 ● 1 ● 1 ● 5

updated 2012-10-12 23:48:13 +0200

Hi all,

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 C:\fakepath\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 !