Accumulated performance, based on total running in pivot

Hi,

I'm trying to do an pivot, where i record deliveries for a period, and eventuelle issues recorded in connection to the delivery. The powerpivot, contains 2 sheets, one showing the all deliveries, 2nd showing deliveries with issues.

Based on these i generated a pivot showing deliveries per week, issues per week, performance per week, accumulated deliveries in period, accumulated issues in period. What i cant do, is creating an accumulated performance for period, inside the pivot?

Hope that you can help.

Attached an Excel file as an example, the cells marked with green, is what i'm trying to do inside the pivot.

BR
Jens

Hi mrwolle,

I haven't used Powerpivot often so this looks like a consolidated pivot to merge the 2 worksheets.

Normally, I would suggest a calculated field

---

but need to know how you created this 'consolidated' pivot.

Cheers

you can use three measures

DeliveryCount:=count(Deliveries[Delivery number])
IssueCount:=Count(Issues[Delivery number])
PerformanceYTD:=CALCULATE([IssueCount]/[DeliveryCount],FILTER(ALL(Deliveries),Deliveries[Delivery week]<=max(Deliveries[Delivery week])))