View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Linda RQ[_2_] Linda RQ[_2_] is offline
external usenet poster
 
Posts: 30
Default First Pivot Table

Hi Everyone,

Using Excel 2003. I created my first pivot table being guided over the
phone and didn't quite remember how I got it grouped by years and quarters
when I tried to do it on my own. I do have a screenshot of the pivot Table
Wizard -layout and in my
Page box I have Therapy Description
Row section I have Quarters and Therapy End Date
Data section I have Count of Admit Number and Average of Vent LOS

I can reproduce everything but the Quarters because I don't have that label
in my new wizard to drag over to my Row section. I have right clicked and
double clicked to see if I could find the dialog screen that I could pull
that up but can't figure it out. I think I remember going through the
wizard then after all my labels were in there, I had to go back to get the
quarters.

Thanks,
Linda