issue in pivot table partial sum

Thu, 04 Sep 2014 20:39:48 GMT

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...

Re: issue in pivot table partial sum

NickHoff — Thu, 04 Sep 2014 20:54:41 GMT

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