Info Aky

' Calc the pivot table to allow the OrdDate label to be drawn PT.ManualUpdate = False PT.ManualUpdate = True

PT.PivotFields("OrdDate").LabelRange.Group Start:=True, End:=True, Periods:=Array(False, False, False, False, True, False, True)

1 Re-Calc the pivot table with the grouped dates PT.ManualUpdate = False PT.ManualUpdate = True

End Sub

Figure 12.33

This order lead time report shows if this manufacturing plant has a 90-day cumulative lead time on components, they'd better have an excellent sales and operations planning system in place.

Ttfal Rtvtnud

0 0

Post a comment