4 Replies Latest reply on Dec 21, 2016 12:32 PM by Logan Brigman

    percentage of total by data source shown on the same bar chart

    Logan Brigman

      I made an example workbook to the point where I get stuck.

       

      I have two data sources that show the results of a survey of the likelihood to recommend a teacher. In the side-by-side bar chart one bar is the data from months 1-4 and the second bar is the data from month 5.

       

      I would like to have the months 1-4 data be only a percentage of total for that teacher from that individual data source. Then the 5 month data to be the same thing where it is a percentage of total for that teacher from that data source.

       

      I keep running into the issue where it is taking the percentage total of all records between both data sources.

       

      Thanks for any help!