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>
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top