+ Reply to Thread
Results 1 to 1 of 1

Trying to create time series database pivot table

  1. #1
    Registered User
    Join Date
    Toronto, Canada
    MS-Off Ver

    Trying to create time series database pivot table


    I want to create a time-series database in a pivot table using multiple data sources (csv files, web pages, etc). Right now I have several connections in a data model with the relationship between them being the date. But when I create the pivot table it doesn't come out as I want it no matter how I play around with the field list. Enclosed I have a sample (Money Market - example) where I have two sheets, one called 'pivot table' with the pivot table from the data model and another called 'goal' which is what I want it to look like.

    Any help would be appreciated.

    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)

Similar Threads

  1. Best Way to Create Time-Series Database
    By illmattic in forum Access Tables & Databases
    Replies: 0
    Last Post: 04-26-2020, 06:29 AM
  2. Change Chart Pivot series Colour depending from Pivot Table Filter value
    By BrianAll in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2018, 02:20 PM
  3. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  4. [SOLVED] Run-time error '5' when trying to create Pivot Table
    By tom_19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2016, 11:52 AM
  5. Recording Macro to create a Pivot Table in Excel 2013: run time error 5 invalid procedure
    By developerstew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2013, 07:17 AM
  6. Replies: 3
    Last Post: 03-08-2012, 11:00 PM
  7. Pivot table and time series
    By Arthurv in forum Excel General
    Replies: 1
    Last Post: 01-06-2012, 10:26 AM


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