+ Reply to Thread
Results 1 to 4 of 4

Need help creating a pivot table based off an example

  1. #1
    Registered User
    Join Date
    06-15-2018
    Location
    North Carolina
    MS-Off Ver
    16.14.1
    Posts
    7

    Need help creating a pivot table based off an example

    Hi guys!

    So I'm new to creating pivot tables and really need help. I was given an assignment to create a pivot table based off an example. I have to make it EXACTLY like the example and I just cant quite figure out how to get the rest of my table to match it. I'm using a mac, btw, if that helps! I could really use some help.

    GREEN COLORED table is what I have so far.

    BLUE COLORED table is what it needs to look like.
    Last edited by msexcelguy; 06-15-2018 at 10:32 PM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Need help creating a pivot table based off an example

    Attach example EXCEL file (not a picture, pasted text or any other than Excel format!). This file should be attached to a new post. Never change your original post (except admin's request).

    In attached Excel file try not to use:
    • merged cells
    • password protection
    • autorun VBA code
    • unnecessary formatting like: colours, borders, aligning another than default, etc...
    • unnecessary zooming/grouping/freezeing
    You have words to logically describe the problem

    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data and contain the result what you want to achieve (manually created if necessary)
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

    note:
    I said attach example excel file
    I didn't say I will help

  3. #3
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Need help creating a pivot table based off an example

    Do you have the sample excel. Can you please attach the same?

  4. #4
    Registered User
    Join Date
    06-15-2018
    Location
    North Carolina
    MS-Off Ver
    16.14.1
    Posts
    7

    Re: Need help creating a pivot table based off an example

    I ended up solving it, thanks for the replies though!

+ 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] Speeding up creating worksheets based upon items in pivot table
    By hdinkie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2016, 05:23 PM
  2. [SOLVED] Error when creating pivot table based on user date range selection
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2016, 04:50 PM
  3. Replies: 2
    Last Post: 08-14-2016, 04:38 PM
  4. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  5. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  6. [SOLVED] Creating a Pivot Table based off an ever changing range...
    By Joven76 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-17-2014, 10:23 AM
  7. Creating two different charts based on a single pivot table based on condition
    By exlnovice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2008, 06:21 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