I am working on a database that I need to pivot off of.
This database includes dates in different columns.
For Example
Unit 1: Start Date 01/01/2013 End Date: 6/30/2014
I need to be able to show that the Unit was worked on in January, February, March, April, May, June.
How can I create one database that I can create one pivot table from to show the months of work? I'd like to be able to toggle between months and see this data on one chart. (Right now im creating multiple charts of months to show the differences).
Thanks for your help!
This database includes dates in different columns.
For Example
Unit 1: Start Date 01/01/2013 End Date: 6/30/2014
I need to be able to show that the Unit was worked on in January, February, March, April, May, June.
How can I create one database that I can create one pivot table from to show the months of work? I'd like to be able to toggle between months and see this data on one chart. (Right now im creating multiple charts of months to show the differences).
Thanks for your help!