I am working with data that has a start date and end date. I have researched building a Gantt chart using a pivot table and I am running into some road blocks. I am new to development, so I may be a little behind the curve. I have been able to create a stand alone Gantt chart, but need to add columns in front and the only way I have seen that this is possible is to use a pivot table.
I have seen a discussion in this forum, but the one I was looking at, was more for someone with a lot more knowledge than I have. I have my pivot built out.
I also have the Gantt calculations as follows:
1: MAX([AP End Date])-MIN([Load Date])
2: interval(Max ([AP End Date] )-Min ([AP Start Date]),'D') & ' days'
In my pivot table I have the following fields:
Primary Owner
LOB 1
LOB 2
AP Start Date
AP End Date
AP ID
AP Name
ID Source
Severity
AP Health
Any help would be greatly appreciated. Thank you for your time!
