Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Pivot Table With Multiple Columns

  1. #1
    Join Date
    31st May 2007
    Posts
    6

    Pivot Table With Multiple Columns

    How do I create a pivot table with multiple data columns? My fixed asset software will not let me create a report to list multiple months/ quarters. I've created a spreadsheet that I can dump each month into, but I'd like to be able to sort by G/L acct or Department. When I try to create a pivot table, I can't get it to accept each month as a data field. Ive attached a copy of the spreadsheet that I'm using & the report that I'd like it to look like.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,049

    Re: Pivot Table With Mult. Data Columns

    I don't think that your source data is laid out to do this. If I undestand you, you need the months in one column.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Pivot Table With Mult. Data Columns

    ryckiej, please don't use meaningless abbreviations in Thread Titles.

  4. #4
    Join Date
    31st May 2007
    Posts
    6

    Re: Pivot Table With Multiple Columns

    My apologies Dave, I didn't realize that mult. (for multiple) was a meaningless abbreviation

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,709

    Re: Pivot Table With Multiple Columns

    Sorry, I meant any abbreviations.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Pivot Table Multiple Columns Data Display
    By kangxiang2000 in forum EXCEL HELP
    Replies: 1
    Last Post: August 15th, 2008, 03:07
  2. Sort Pivot Table By 2 Columns
    By adrpo in forum EXCEL HELP
    Replies: 2
    Last Post: June 29th, 2007, 19:47
  3. Pivot Table Data In Multiple Columns
    By rpaulson in forum EXCEL HELP
    Replies: 4
    Last Post: June 1st, 2007, 06:32
  4. Pivot Table List From Multiple Columns
    By kdnichols in forum EXCEL HELP
    Replies: 2
    Last Post: May 12th, 2007, 17:14
  5. Pivot Table Based Off Multiple Pivot Tables
    By udhay28 in forum EXCEL HELP
    Replies: 3
    Last Post: September 7th, 2006, 10:03

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
  •  
porno