Hi there, I work with a mount of data on daily basis and I use pivot as my tool. As my data grows bigger every month, I delete the old data and save it per month. But I still see in my pivot selection the old dates (not the data). How can I delete these historical dates? Because I have to go through all dates up to current date for some analysis that I need to make. Please help me out. -- Thanks for the helps Wildan
"wildan" wrote in message news:B05552CB-F603-4806-9E53-EA3CF35C6FA8@microsoft.com... > Hi there, > I work with a mount of data on daily basis and I use pivot as my tool. As > my > data grows bigger every month, I delete the old data and save it per > month. > But I still see in my pivot selection the old dates (not the data). How > can I > delete these historical dates? Because I have to go through all dates up > to > current date for some analysis that I need to make. > Please help me out. > > -- > Thanks for the helps > > Wildan Can you provide some contextual information? What software are you using, and are you looking for a procedural or programmatic solution?