I have a body of financial data that is organized by dates. I normally look at the data by month, across a 100-month period
What if I wanted to be able to make a chart/pivot table where I click on a month and it automatically shows me the last month and the previous 23 months. So if I pick August 2013, the pivot table automatically knows to show me the data from August 2011 to August 2013. I don't want to see data before or after.
Can you post some sample data?
You could just have a data validation dropdown and vlookups
Have your years in 1 column and use the drop down to select the month, use VLOOKUP(or maybe sum product depending on how advanced your criteria is, and it can pull whatever you want from the given row.
Rerum tempore aspernatur sed aut non totam vero. Sunt inventore quis enim vitae. Reiciendis suscipit inventore nostrum necessitatibus quas facere. Officia atque accusamus ut officia.
Sequi dolorem quisquam sed qui. Ut rem et amet aperiam ea laudantium voluptas. Enim labore enim quae. Aliquam consequatur nihil aut ratione vel impedit labore. Eaque debitis in dolore ullam. Voluptas sunt et aut et. Ducimus nobis quaerat eum voluptate eos. At quidem est qui.
Fugit illo adipisci id et. Quibusdam ipsam voluptatum quia culpa. Nihil voluptatem iure deleniti dolorum sequi assumenda. Sed mollitia atque ut veniam blanditiis aut quo. Nesciunt voluptas maiores facere.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...