+ Reply to Thread
Results 1 to 3 of 3

Pivot table - how to filter on a period (from-to) filled in by hand

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    5

    Pivot table - how to filter on a period (from-to) filled in by hand

    Hey guys,

    Here goes. I've created a dashboard (see for an example the business case I attached) using search strings collecting data from multiple pivot tables. The original data is sorted and prepared in MS Access so I have a good table to use for the pivot tables.

    I've tried to make it dummy prove: a user van type the organisation name he/she wants a dashboard of in cell V1 in the first tab.
    The search strings try to look up the values connected to the organisation in the other tabs and display the value in the right hand part of tab1: dashboard.
    The left hand part displays the value either in a graph or a table.
    It works and is pretty dummy prove!

    Anyways.. now I have to add a date filter (as there can be multiple projects for a single organisation). In the source data I have a field called entry date which is the date when a candidate is added to the database.
    I have to filter the pivot tables on this entry date in a specific period (eg. from 01-01-2012 to 02-01-2012). I has to be equally dummy prove as typing in the organisation name, so I'd prefer adding cells in the dashboard saying 'from' and 'to'.

    Can somebody help me??

    PS: any feedback on how I make the dashboard is very welcome!


    Business case.xlsx
    Last edited by romkedj; 09-24-2012 at 11:29 AM. Reason: Title didn't get me a lot of viewers.

  2. #2
    Registered User
    Join Date
    09-20-2012
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pivot table - how to filter on a period (from-to) filled in by hand

    I could still use some help on the issue! Please enlighten me!

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Pivot table - how to filter on a period (from-to) filled in by hand

    2nd bump, still no response!

+ 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