+ Reply to Thread
Results 1 to 2 of 2

excel pivottable

  1. #1
    Registered User
    Join Date
    05-07-2009
    Location
    Phoenix, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    1

    Smile excel pivottable

    i have data entered into a spread sheet the columns incl. (yr, month, id, date, long, short, entry, exit1, exit2, tpoints, tdollars, increment, & full turn). its is trading data arranged from 2000-09, I am trying to make a pivottable out of the data. I want to make a cascading hierarchy, with the years in the columns, i want to make each month of the particular year tab down vertically, then under that have each record incl. id, date, long, short, entry, exit1, exit2, tpoints, tdollars, increment, full turn.

    I hope all this makes sense, appreciate help.

    paul

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: excel pivottable

    Hi Paul, and welcome to the forum.

    Your best bet with this one is to provide a spreadsheet with some sample data and the final result you are seeking. Pivot tables are tough enough to do without having to do them in your head.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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