date calculation in pivot table to show products over agreed date?

A

applesandpears

hi all, am new to this forum so please bear with me.
I have the following query:
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 complet
months.

2)***** Represent graphically:
a.****** Monthly order growth per customer
b.***** Current order status for those started in the last two months.

and not sure how to calculate dates in excel. I have the agreed SL
agreed date and days and also the order start and finish dates an
orders?

I appreciate any help! and thank you for your tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATE Calculations in pivot table 0
Pivot Table Calculation 4
Calculating total amount in a Pivot Table 1
filtering dates in a Pivot Table Report Filter 3
Subtract colums in pivot table 0
Grouping Date Fields in Pivot Table 2
How to do counts, additions and averages in XCEL pivot table. 0
How to find weeknumber when my table contains a date 4

Top