View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lorie Lorie is offline
external usenet poster
 
Posts: 30
Default How would you show this in a piviot table?

I want my pivot report to total all billable and non billable minutes for one
client,
in other words the bill able minutes are 150+90 in this case, which equals 240
We bill in 15 minute units, in this case, 240/15=16 units that i can bill on.

How would you show this in a piviot table? I hope i am being clear?


Billable Minutes 150
Non-Billable Minutes 0
Billable & Non-billable Minutes 150
_______________________________
Billable Minutes 90
Non-Billable Minutes 25
Billable & Non-billable Minutes 90

--
thank you, Lorie