6 Replies Latest reply: Dec 14, 2017 9:49 AM by Belia Romero RSS

    Gantt (Pivot Table) with multiple values for a dimension

    Belia Romero

      Hi,

      Is there a way to create a gantt diagram with more than one value for each dimension?

      My data looks like:

       

      IDTypeSubtypeFromTo
      AA1A1101.01.201813.01.2018
      AA1A1205.01.201810.01.2018
      AA2A2115.12.201715.01.2018
      AA3A3103.11.201718.12.2017
      AB4B1124.11.201725.11.2017
      ...............

       

      In my chart I want to show the ID, the type and the calendar info. I followed this example: How to create a Gantt chart using a Pivot table, however it only works for one value per dimension (A1 will not be shown, since it is the aggregation of A11 and A12 subtypes).

      My goal:

      goal.PNG

      What I have:

      Gantt.PNG

       

      I appreciate any ideas or suggestions?