+ Reply to Thread
Results 1 to 3 of 3

Get Column total and one of the item total.. is it possible?

  1. #1
    Registered User
    Join Date
    08-29-2005
    Posts
    6

    Get Column total and one of the item total.. is it possible?

    I am not sure how to word so apologize if the title is confusing.

    Please see attach image. I want to create a pivot table that looks like the table I created manually. I want to see Total # Priority and how many of they are automated (in %). I tried hiding/filtering the "Not automated", then when I did that total did not match.

    Thank you in advance.

    pivot.png

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,430

    Re: Get Column total and one of the item total.. is it possible?

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,430

    Re: Get Column total and one of the item total.. is it possible?

    Administrative note

    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

+ 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: 3
    Last Post: 02-11-2015, 02:47 AM
  2. Get the total of the same item in a column
    By jotol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2013, 10:36 AM
  3. Replies: 0
    Last Post: 09-01-2009, 05:41 AM
  4. Replies: 5
    Last Post: 10-14-2008, 11:14 PM
  5. [SOLVED] calculated item does not work in grand total column- Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:35 PM
  6. calculated item does not work in grand total column in Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:35 PM
  7. [SOLVED] calculated item does not work in grand total column in Pivot
    By Valerie_NOLA in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 02:30 PM

Tags for this Thread

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