

October 25, 2013

Hi All,
Love this forum, its great.
Please review the attachment below. This is the result I wish but not too sure how to get there.
I can create the whole pivot with little trouble, what I don't know how to (or if it can be done within a pivot) is the row with the Jan Avg for each month.
I want to know the percentage of tickets completed in the 12am to 6am, 6am to 6pm and 6pm to midnight period over to full month.
I hope this makes sense.
Thanks


October 25, 2013

Hi Mynda,
Thanks for the reply!
Actually no, I want to keep the values as they are shown, as per my example on "Final Outcome", I want to sum all the 3 values under 12am to 6am 259, 249 and 294 and on row 5, and then divide by the total 2792 on P3 to get the percentage of tickets for that time period.
I don't know if this is possible within a pivot table, but thought I would throw it out there.
Thanks
Most Users Ever Online: 57
Currently Online:
18 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas