4 Replies Latest reply: Apr 20, 2016 7:35 AM by pradeep t RSS

    how to handle hierarchy in excel sheet

    Viresh Kolagimath

      Hi team,

      I have below data which needs to bring into QV but if you look at first column, it contains hierarchical data that is APJ region contain India , Aus etc countreis but in NA i dont have the same structure.

       

      Need your help on this. Thank you.

       

      Regards,

      Viresh

       

        

      Sales20102011
      APJ1010
             India22
            Aus44
            China22
            Japan22
      USA1212
      EMEA1214
            UK33
           Germany33
           Italy66
          France02
      Total3436