Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table to show date ranges and if over date
Hi all, am new to this thread and was wondering if you could help me. I have to do the following:
1)***** Build pivot to calculate things like: -********* Average lead time per order type -********* Average lead time per platform -********* Orders breached SLA per month for the last six complete months. 2)***** Represent graphically: a.****** Monthly order growth per customer b.***** Current order status for those started in the last two months. on the following data: start Date end date Product /order type Customer Sales lead time per order(days) platform SLA Agreement days 12/09/2012 20/09/2012 Mobile Customer14 $45,446.00 20 platform yellow 15 13/09/2012 22/10/2012 fixed line Customer20 $43,703.00 34 platform purple 15 17/09/2012 23/10/2012 gsm Customer11 $45,446.00 20 Platform blue 15 19/10/2012 24/10/2012 handset Customer5 $97,346.00 20 platfom white 15 19/09/2012 25/10/2012 icloud Customer6 $45,446.00 50 platform red 15 20/09/2012 26/10/2012 iphone Customer15 $52,107.00 120 platform black 15 23/09/2012 14/11/2012 samsung Customer12 $52,107.00 30 platform purple 15 23/09/2012 15/11/2012 Mobile Customer8 $43,703.00 30 platform red 15 24/10/2012 16/11/2012 fixed line Customer7 $52,107.00 50 platform yellow 15 25/09/2012 17/11/2012 gsm Customer20 $45,446.00 22 platform black 15 27/09/2012 18/11/2012 handset Customer18 $85,604.00 34 Platform blue 15 28/09/2012 19/11/2012 icloud Customer17 $45,446.00 50 platform pink 15 01/10/2012 20/11/2012 iphone Customer2 $97,346.00 20 platform black 15 01/11/2012 14/11/2012 samsung Customer6 $43,703.00 100 platform black 15 04/10/2012 14/10/2012 Mobile Customer4 $85,604.00 30 platform pink 15 am not sure how to submit the excel worksheet? please any help would be very much appreciated! |
#2
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - show monthly data based on start/end date data | Excel Programming | |||
Comparing Date Ranges in one Table to Date Ranges in another Table | Excel Programming | |||
Wanted to show 12 month Date in Pivot table | Excel Programming | |||
Pivot Table sorts date as Alpha, not as Date | Excel Worksheet Functions | |||
using date ranges in a pivot table | Excel Programming |