4 Replies Latest reply on Oct 27, 2018 12:26 AM by an.dy

    Create stacked bar chart based on data stored in a predefined format

    an.dy

      Hi all,

       

      I have a data in a format like:

      1.JPG

       

      Here we have TotalHoursGrade[X] number defined for each Grade and for each Group. (The numbers do duplicate in rows inside a group).

       

      I need to get a stacked bar chart like:

      2.JPG

       

      Can you help me to do that?

       

      Source file attached.

       

      Limitation: I can not remove any rows from data, I can only add columns/calculations (as rows are filled with different data in original file).

       

       

      Thanks!