View Column Totals Incorrect Calculation Problem

Dear ALL,

I have a view which I enable the column “Totals” to auto sum up the column’s value.

However the resulted value do not discard those hidden documents that is not display in the view.

[hidden= my ID has no access to the document]

Ex.

Document 1: 20 (Not hidden)

Document 2: 30 (Hidden)

Document 3: 40 (Hidden)

The total display in the view should be 20, but the system return 90.

Do you guys have any suggestions how to overcome this problem?? Or another better way to get the column’s sum.

THANKS SO MUCH =)