+ Reply to Thread
Results 1 to 9 of 9

How do I add a simple % column

  1. #1
    Registered User
    Join Date
    11-25-2020
    Location
    UK
    MS-Off Ver
    Excel version 2011 Build 13426.20274
    Posts
    3

    How do I add a simple % column

    image_2020-11-25_094631.png


    Hello, I am trying to add a simple percentage column on a pivot chart and it seems very hard to do .
    I want to show all the % of all records for each campaign where there was a meeting.


    Record ID Campaign Meeting Date
    1234 A 12/12/2020
    1235 B
    1236 A 06/06/2020
    1237 C 07/07/2020
    1238 A
    1239 B 02/02/2020
    1243 A




    Campaign Count of Records Count of Meetings % of Meetings
    A 4 2 50%
    B 2 1 50%
    C 1 1 100%
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-25-2020
    Location
    UK
    MS-Off Ver
    Excel version 2011 Build 13426.20274
    Posts
    3

    Re: How do I add a simple % column

    I've been trying all day, I don't think this is possible.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: How do I add a simple % column

    It is possible with PowerQuery, but I think your version of Excel is for Mac, and if so, you won't have PowerQuery, unfortunately.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: How do I add a simple % column

    Here's how with PQ, for anyone who has it and is interested.

    M Code:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: How do I add a simple % column

    Is it so basic, or I missed sth?

    E16
    =COUNTIF(Table1[Campaign],[@Campaign])

    F16:
    =COUNTIFS(Table1[Campaign],[@Campaign],Table1[Meeting Date],">0")

    G16
    =[@[Count of Meetings]]/[@[Count of Records]]
    Attached Files Attached Files

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: How do I add a simple % column

    Well, the OP couldn't even be bothered to acknowledge either suggestion. Feels like a hit and run. Some people have no manners.

  7. #7
    Registered User
    Join Date
    11-25-2020
    Location
    UK
    MS-Off Ver
    Excel version 2011 Build 13426.20274
    Posts
    3

    Re: How do I add a simple % column

    Hello AliGW, it's certainly not a hit and run. I have posted two replies and none seem to have appeared.
    Thank you for your help

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,258

    Re: How do I add a simple % column

    LOL! You didn't save the replies, then.

    Did either solution help? If so, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  9. #9
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,196

    Re: How do I add a simple % column

    If you actually want a pivot table (your initial post looks like a regular table) you just need to add two columns to your source data: one that returns 1 for every row and one that returns 1 if the meeting date field isn't blank. You can then SUM those columns to get a count, and use those fields in a calculated field to create the percentage you need.
    Rory
    I drink, and I know things

+ 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: 4
    Last Post: 03-28-2020, 08:45 PM
  2. [SOLVED] Simple column format
    By emueller in forum Excel General
    Replies: 3
    Last Post: 03-03-2020, 10:20 AM
  3. Time in column A Value in Column b, should be simple enough to make a graph ?!
    By Azzheasman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2018, 02:39 PM
  4. Simple question: Plot column with text vs column with values
    By Morridini in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-11-2014, 12:24 PM
  5. Replies: 3
    Last Post: 09-01-2013, 06:51 PM
  6. [SOLVED] Simple formula to match column A, sheet1, with column A, sheet2, return text answer
    By Connie5761 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2012, 02:56 PM
  7. Simple 3D Column
    By thepict@albaweb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-22-2006, 11:40 AM

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