Partial Sum On A Pivot Incorrect - Duration (Time)

[#1]

Hi There

I am having issue with a pivot chart, My Grouped (Sum) value is incorrect. Here is the issue

Expanded the value correspond field (Total Time)

Colapsed the value goes totally wrong

thanks i have attached the qvw too 

[#2 · Accepted solution]

Hi there i figured it out thanks.I made changes to my sql. Removed Max and Min From equations. see attachment