+ Reply to Thread
Results 1 to 1 of 1

Pivot table questions...

  1. #1
    Registered User
    Join Date
    03-15-2010
    Location
    chicago
    MS-Off Ver
    Excel 2003
    Posts
    12

    Pivot table questions...

    Hello! wondering if anyone has any suggestions for formatting / altering my pivot table into a more desirable format, or if maybe there is an alternative to the pivot table. Currently I have the following data fields in my raw data: Date, Product, Strike price, # of calls, # of puts. I chose to sort the data using a pivot table because the input data will be constantly changing and I need all the sorting to happen automatically every time data is changed.

    I want to add up all calls and puts of every strike price for each month, regardless of product type, then in separate columns show the breakdown of the sum by products. The end result that I want ideally would look something like this (these are made up numbers):

    April 2010:
    strike price__#calls__#puts__sum (calls+puts)_product 1__product 2__product 3

    1000________50______100______150__________75_______50________25
    1050________75______-100______25___________50______-25_________0

    May 2010
    (same as above...and so on for each month of data)

    I've attached a file containing my raw data - as you can see a lot of the data has zeros and I dont want these showing up in the output fields. Any suggestions?? I appreciate any ideas anyone may have.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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