Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP..... Pivot report error
I have a pivot report, that I am counting minutes worked on....
Total time worked (End time - Start Time) =(C2-B2)*1440 Some of the time is billable - (Activites 1 - 4 are billable) =(F2<4)*I2 Some time is not billable - (Activite 5) =(J2<1)*I2 7:00 AM 9:05 AM 5 125 0 125 9:05 AM 9:45 AM 3 40 40 0 9:45 AM 10:10 AM 5 25 0 25 type of work Total Billable non billable But when I pivot it, I don't get the correct data... I get a 1 for time that is billable and a 1 for time that is not billable, yet the total billable works..... see below.... Total Billable & Non-billable Min. =190 minutes worked "Total Billable Minutes 1-4" Are equaling "1" for minutes billable "Total Non-Billable Minutes 5" Are equaling "1" for minutes non billable can you help me figure out what is going wrong? What I might need to fix? I am now at a loss...... -- thank you, Lorie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP..... Pivot report error
How is your pivot table set up? What fields are in the Row, Column and Data
areas? Are these incorrect totals the Grand Totals, or subtotals for a Row field? From what you've shown as the data source, you should be able to add the Total, Billable and Non billable fields to the data area, to get the correct totals. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "Lorie" wrote: I have a pivot report, that I am counting minutes worked on.... Total time worked (End time - Start Time) =(C2-B2)*1440 Some of the time is billable - (Activites 1 - 4 are billable) =(F2<4)*I2 Some time is not billable - (Activite 5) =(J2<1)*I2 7:00 AM 9:05 AM 5 125 0 125 9:05 AM 9:45 AM 3 40 40 0 9:45 AM 10:10 AM 5 25 0 25 type of work Total Billable non billable But when I pivot it, I don't get the correct data... I get a 1 for time that is billable and a 1 for time that is not billable, yet the total billable works..... see below.... Total Billable & Non-billable Min. =190 minutes worked "Total Billable Minutes 1-4" Are equaling "1" for minutes billable "Total Non-Billable Minutes 5" Are equaling "1" for minutes non billable can you help me figure out what is going wrong? What I might need to fix? I am now at a loss...... -- thank you, Lorie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Break Link cause Send Error Report | Links and Linking in Excel | |||
saved worksheet opens in new with macro error report | Excel Worksheet Functions | |||
Excel opens with an error report whenever I Boot Up my computer | Excel Discussion (Misc queries) | |||
Error report closing excel | Excel Discussion (Misc queries) | |||
A pivot table report cannot overlap another pivot table report. | Excel Discussion (Misc queries) |