Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Try SUM(TOTAL processqty), does that give you the correct result? Adding the TOTAL causes the expression to ignore the dimension(s), when summing.