Partial Sum On A Pivot Incorrect - Duration (Time)

Tue, 08 Nov 2011 11:02:48 GMT

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

Re: Partial Sum On A Pivot Incorrect - Duration (Time)

Tue, 08 Nov 2011 11:24:25 GMT

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