+ Reply to Thread
Results 1 to 2 of 2

Using Pivot Tables with 2 Different Date Variables x 2

  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

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Using Pivot Tables with 2 Different Date Variables x 2

    See attached file, I hope that it's what you need.

    I added two columns in which you can test purchase dates and if they are in the range of dates that you desire then the sold amount is the same, else is zero.

    Really the column with 'ok' is not needed and it's possible to remove.

    Regards,
    Antonio
    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. 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. [SOLVED] Using variables with pivot tables
    By Lorraine G in forum Excel General
    Replies: 2
    Last Post: 01-31-2006, 07:35 AM
  7. 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