issue in pivot table partial sum

[#1]

Hi

I have a pivot table named as Daily Statistics.

I have two dimension which are Date and Week Name.

The Expressions are

1. Start   - Min(PGAuditDateTime) and showed this in time format

2. End    - max(PGAuditDateTime) and showed this in time format

3. Hours  - (Interval(Max(PGAuditDateTime)-Min(PGAuditDateTime),'h:m')*24)-.83  -- difference between End and Start in hours

4. Graded  - sum(GradedQty)

5. Processed  - sum(ProcessQty)

6. Tires / hour  - (sum(ProcessQty)/((Interval(Max(PGAuditDateTime)-Min(PGAuditDateTime),'h:m')*24)-.83))

When i apply partial sum, it gives me wrong values, for example in the chart i attached

Sum(processqty) = 1327588

Hours = 454.96

Tires/Hour should = 2918

What is displayed is 1872

can you have a look on that and let me know...

[NickHoff]

Try SUM(TOTAL processqty), does that give you the correct result?  Adding the TOTAL causes the expression to ignore the dimension(s), when summing.