Help - Pivot

[Dushyant Rajput]

Hello,
My Query look like:-

Using the data on the "Raw Data" tab, please use the Excel Pivot Table
functions to display the total calls Offered by CallTypeDirn by Day like the
following:

CallTypeA CallTypeB CallTypeC
June 5
June 6 (Calls Offered)
June 7
June 8
June 9
June 10
June 11

Dates should be grouped by Interval and only include the Hours of Operation
of the project. Hours of Ops for this data is 6am to 3pm Sat and Sun and
5am to 9pm Mon - Fri.

And Raw data look like:
IntervalBegin CallTypeDirn HandleInSL HandleOutSL Offered
6/5/05 5:00 87883 1 0 2
6/5/05 6:00 87345 30 0 30

6/6/05 6:00 87883 2 0
3


Thank you

 

[Debra Dalgleish]

What have you done so far, and where are you getting stuck?

 

[Dushyant Rajput]

Hi Debra,

Following is the somesnap shot of what I have done so far, I am not able to
decide how to make validation in Pivot like if you have given time interval
of 24 hrs and you have asked to choose interval between 3 am to 9 pm and so
on.

Main Prob:- time interval is giving for 24 hrs but I have to select some of
it and its for 7 days . so how do I make pivot to take selected time
interval.


Sum of Offered CallTypeDirn
Date IntervalBegin 84864 84884 87133 87345
6/5/2005 1 795
6/6/2005 152 66 4 1716
6/7/2005 116 36 1604
6/8/2005 104 32 4 1460
6/9/2005 112 47 2 1520
6/10/2005 133 54 2 1416
Grand Total 617 235 13 8511

 

[Debra Dalgleish]

Since the hours of operation are different on weekends, you could add a
column in the source table, to calculate if the call was during
operating hours. Then, add that field to the page area of the pivot
table, and use it to filter the pivot table for only the valid calls.