I have a worksheet with outage times for our various services. Per incident
I have the duration in minutes. I convert this duration into weekly,
monthly, and yearly downtime percentages.

I have created three pivot tables that pull this data in. The result is
something like this:

Email 694 0.068849206

694 is the total sum of minutes that the service e-mail was down in the
given time period. 0.06... is the total downtime percentage for the service
Email.

ALL I want to do is convert the later downtime number into uptime.
0.068849206 would become 93.12% uptime.

Very simple, right? I could easily do this with a normal field but I can't
figure out how to do this in a PivotTable. I see the "Show values as" option
but it seems unable to reference a specific number. It wants to do column
comparison row by row.

Any help will be much appreciated.

Thank you,
Clifton Griffin

Hi,

May be simple. How is your raw data laid out and how do you reach the %down
figures?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"clifgriffin" wrote:

I have a worksheet with outage times for our various services. Per incident
I have the duration in minutes. I convert this duration into weekly,
monthly, and yearly downtime percentages.

I have created three pivot tables that pull this data in. The result is
something like this:

Email 694 0.068849206

694 is the total sum of minutes that the service e-mail was down in the
given time period. 0.06... is the total downtime percentage for the service
Email.

ALL I want to do is convert the later downtime number into uptime.
0.068849206 would become 93.12% uptime.

Very simple, right? I could easily do this with a normal field but I can't
figure out how to do this in a PivotTable. I see the "Show values as" option
but it seems unable to reference a specific number. It wants to do column
comparison row by row.

Any help will be much appreciated.

Thank you,
Clifton Griffin

=1-((10080-Table__11_3_08[[#This Row],[Minutes]])/10080)

The referenced number (Table__...) is the number of minutes down for that
specific incident. This is so I can simply add it up in the pivot table to
get the total downtime for all incidents bearing that title.

Does that make sense?

Thanks for your prompt response,
Clifton

"Shane Devenshire" wrote:

Hi,

May be simple. How is your raw data laid out and how do you reach the %down
figures?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"clifgriffin" wrote:

I have a worksheet with outage times for our various services. Per incident
I have the duration in minutes. I convert this duration into weekly,
monthly, and yearly downtime percentages.

I have created three pivot tables that pull this data in. The result is
something like this:

Email 694 0.068849206

694 is the total sum of minutes that the service e-mail was down in the
given time period. 0.06... is the total downtime percentage for the service
Email.

ALL I want to do is convert the later downtime number into uptime.
0.068849206 would become 93.12% uptime.

Very simple, right? I could easily do this with a normal field but I can't
figure out how to do this in a PivotTable. I see the "Show values as" option
but it seems unable to reference a specific number. It wants to do column
comparison row by row.

Any help will be much appreciated.

Thank you,
Clifton Griffin

Excel 2007
Percentage for week, month, year groups.
Pivot Table, Table, Macro.
Two methods:
http://www.mediafire.com/file/anyilzyexye/03_02_09.xlsm