Results 1 to 2 of 2

Using Pivot Tables with 2 Different Date Variables x 2

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2016
    Location
    San Diego, CA
    MS-Off Ver
    Office 2016
    Posts
    5

    Using Pivot Tables with 2 Different Date Variables x 2

    Hello,

    I couldn't really describe this in an "Easy" language, as my first language is not English, but I'm having some trouble using Date as variables.

    So I have this data set:
    excel1.png
    Notice that everyone buys Product #1, but not everyone bought Product #2.

    From this, we get our regular pivot table:
    excel2.png
    Now, what's the problem?

    I can't change the dates at will! What if I want to do any dates between 1/1 and 2/28 for Product 1 purchase dates? Yeah, on a small data set we can individually uncheck based on filter, but on a big data set that won't be possible.

    This is what I'm looking to do:
    excel3.png

    I'm so sorry if it doesn't make complete sense - I'll be more than happy to clarify confusion.

    I would appreciate any help in this matter and thank you for reading!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. three variables pivot tables
    By mattyoxford in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-02-2016, 07:44 PM
  2. Replies: 1
    Last Post: 04-06-2016, 03:52 PM
  3. VBA to update pivot tables date between value - Date error
    By delboy2405 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:46 PM
  4. Date formats in pivot tables using power pivot in Excel 2010.
    By myobreportguru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2013, 10:21 PM
  5. Transfer Data to separate tables based two variables (date and site)
    By yunesm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2009, 08:30 PM
  6. Using variables with pivot tables
    By Lorraine G in forum Excel General
    Replies: 2
    Last Post: 01-31-2006, 07:35 AM
  7. [SOLVED] Pivot tables and array variables
    By JAdamJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2005, 11:30 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