+ Reply to Thread
Results 1 to 2 of 2

Show Values As (modified) ?

  1. #1
    Registered User
    Join Date
    05-10-2019
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    1

    Question Show Values As (modified) ?

    Hi All,

    Labeled some raw daily data w/ corresponding day of week to create a pivot table. Set Columns as "Day of Week" with the Values set to an average of the metric I'm looking at.

    I'm trying to see the relative performance of each day compared to the total average, and at a basic level that was satisfied by "Show Values As > % of Row Total."

    However, instead of the values reading as 100%, 90%, 110%, I'd rather see the % delta from the average. So, 0%, -10%, and 10% respectively.

    Any help is appreciated!
    Attached Images Attached Images

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Show Values As (modified) ?

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] show last modified date of a cell
    By rachelwahid in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-17-2017, 03:31 AM
  2. show last modified date of a cell
    By rachelwahid in forum Excel General
    Replies: 2
    Last Post: 08-13-2017, 04:35 AM
  3. Show today's date if specified cell is modified
    By xavpg in forum Excel General
    Replies: 7
    Last Post: 02-28-2012, 07:16 PM
  4. Show date last time modified
    By José Manuel Soberón in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2006, 05:10 AM
  5. Show date cell modified
    By manxman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2006, 07:50 PM
  6. Automatically show new date in the modified cell
    By NYBoy in forum Excel General
    Replies: 9
    Last Post: 10-04-2005, 11:55 AM
  7. show date modified in a cell
    By Lana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1