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


      Hi all,


      I have a data in a format like:



      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:



      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).