Paul12345671
Technical User
Hello,
I've got data displayed on a pivot table, and amongst other attributes, it displays the date. The users will be asking questions like "show me data for the last 3 months", (or the last 3 days or the last 3 weeks or maybe the last 12 months). As it stands, they need to go to the filter option, then click a bucketload of dates to display the dates they want. The users would prefer to simply enter a value like ">1/1/2008". I've tried adding the standard "Filter" button to the menu bar, but Access automatically disables it (I suppose that you can't use it in pivot tables).
Does anyone know how I might allow users the ability to filter pivottable data , based on a range?
Thank you.
I've got data displayed on a pivot table, and amongst other attributes, it displays the date. The users will be asking questions like "show me data for the last 3 months", (or the last 3 days or the last 3 weeks or maybe the last 12 months). As it stands, they need to go to the filter option, then click a bucketload of dates to display the dates they want. The users would prefer to simply enter a value like ">1/1/2008". I've tried adding the standard "Filter" button to the menu bar, but Access automatically disables it (I suppose that you can't use it in pivot tables).
Does anyone know how I might allow users the ability to filter pivottable data , based on a range?
Thank you.