usime time in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to show an improvement in lapsed times for patient assessments
and want to pivot the data. I know its possible because I have a similar
chart in front of me but when i drag the lapse time field into the table (The
x axis is days of week and the y axis is shifts (day night evening) I only
get the count of the times and not the data. I have tried formatting as hh:mm
but that changes the data to 00:00. Can anyone assist
 
Hi kriptik,

Double click on the title of the pivot table that probably says 'Count of
Times' and select Sum from the menu window that pops up.

Ewan.
 

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

Determine if night shift by start & end time 2
Grouping in Pivot Table 3
Pivot Table date format 1
pivot table counting 1
Lapsed Time 2
Pivot table help 2
Pivot table filter list - listing irrelevant subcategorys 1
pivot table chart 7

Back
Top