1 Reply Latest reply on Oct 4, 2016 9:59 PM by Shinichiro Murakami

    Manipulate Data  Grouping removing unnessary fields

    linda.whittle

      So,  I am running into an
      issue with handling the data.  I have too much information and if I
      exclude some data I don’t have enough. 

      I am looking for this format
      so I can graph/display easily. 

       

      On the excel file, I am showing
      in red what I don’t need to be displayed so it doesn’t transfer in to the
      visual side.  Column E is showing you how I am getting that percentage
      instead of hunting in the workbook. 

      Any thoughts on the easiest way
      to do this?