+ Reply to Thread
Results 1 to 1 of 1

Pivot and/or chart to group data by conditions

  1. #1
    Registered User
    Join Date
    05-21-2015
    Location
    Austin, TX
    MS-Off Ver
    2013
    Posts
    19

    Pivot and/or chart to group data by conditions

    I'm pretty new to Pivots and Charting, have reviewed a bunch of sites online and videos but how to do this is just escaping me. I have the attached workbook to work with; the data tab is generally blank in the template, and the end user pastes the data they want to review; all other sheets should then calculate/update based on the new data.

    They want to see the % of orders that took 20 days or longer to install, as well as those that took 10 days or less to install, delineated by month. The ability to see the % of middle ground (11-19 days) would be helpful as well.

    I'm sure I could do this by writing formulas or editing data layout in other tabs and then creating a Pivot off of that - but isn't there a way to put a "condition" or a "formula" like "=Days_to_Installation>=20" within the Pivot itself?

    Also, any suggestions for how to best chart this data to convey to the end user where their team stands in month-over-month performance at getting the orders installed in <20 days?

    Thanks in advance. Hoping to learn more from this specific instance than I've been able to from others generic sample data sets.

    David
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 02-15-2017, 11:24 PM
  2. [SOLVED] Highlighting part of the pivot chart based on conditions
    By R12345 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-25-2016, 07:13 PM
  3. [SOLVED] Can't group dates on my pivot chart
    By David_Patsy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2014, 12:26 AM
  4. Replies: 1
    Last Post: 12-31-2010, 03:31 AM
  5. Chart Group Data Combinations?
    By misscrf in forum Excel General
    Replies: 1
    Last Post: 08-09-2010, 08:49 PM
  6. Changing group names in a pivot chart
    By atmosphereee in forum Excel General
    Replies: 0
    Last Post: 07-16-2010, 04:15 PM
  7. [SOLVED] Pivot table/chart - can I use data ranges? why will it not group d
    By Forrest in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-10-2006, 03:30 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