Correct me if I'm wrong but it seems like the total giving in NXT's constituent 'Giving' Summary is calculated differently from database view's 'Total Giving' in the prospect tab:
NXT Giving Summary: Total Gifts from Constituent, pledge balance, and soft credits = Lifetime Giving
Database View Total Giving (Prospect Tab): Total Gifts from Constituent, plus pledges (regardless of whether the pledge is fulfilled by other constituents) = Total Giving (soft credits are not included in total giving here)
It would be helpful if the same information was presented between the 2 views.