LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default This seems like it should be so simple! (PivotTable "Show values a

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
This seems like it should be so simple! (PivotTable "Show values a clifgriffin Excel Discussion (Misc queries) 3 March 3rd 09 05:10 PM
Array: Show only min values greater than "0" Arno Excel Programming 6 February 16th 09 12:09 PM
Show "+" (plus) sign when comparing two values filpass Excel Discussion (Misc queries) 7 November 14th 08 01:34 PM
Find "Look in" box does not show 'values' on 'formulas' Oldnovice Excel Worksheet Functions 2 April 28th 08 08:02 PM
are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "? broro183[_13_] Excel Programming 4 January 17th 06 10:46 AM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"