pivot table and dates to show average times for products and ones over the agreed date

applesandpears

New Member
Joined
Oct 16, 2012
Messages
15
Hi all, am new to this forum so exuse me if I havent provided enough detail but this is all I have!
I have an interviw after 7 years of being work on maternity leave ;) :eek:and my excel is not what it used to be but have been practising with the help of MR Excel!!
:)The following is what i have to do but have been given no data to do this:
1) Build pivot to calculate things like:</SPAN>
- Average lead time per order type</SPAN>
- Average lead time per platform</SPAN>
- Orders breached SLA per month for the last six complete months.</SPAN>
2) Represent graphically:</SPAN>
a. Monthly order growth per customer</SPAN>
b. Current order status for those started in the last two months.

If you could provide links or explain how to do this it would be very very much appreciated!!!

My interviw is on Thursday!!!!

I hope someone can help!!!
</SPAN>
Thank you all for reading ;)

<TBODY>
</TBODY><COLGROUP><COL span=8></COLGROUP>
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

applesandpears

New Member
Joined
Oct 16, 2012
Messages
15
Hi Cyrilbird and everyone else!

I have read these but am struggling to put the steps together to achieve what I need below? Is it a lot more simpler then i think? At the moment am feeling a bit overwhelmed!:eek::eek:

Amarjit
 

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
it is a lot simpler than you think.
best approach is for you to duplicate the examples seen in the links and do what is shown, thus you'll develop confidence and understanding.
difficult to give more appropriate feedback as you stated that you have no data.
 

applesandpears

New Member
Joined
Oct 16, 2012
Messages
15
Hi, i have an excel file i can send to help? how would i send this?
your help is very much appreciated!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,408
Messages
5,528,603
Members
409,827
Latest member
Tmcgrew05

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top