1 Reply Latest reply: Jun 21, 2016 1:47 AM by Nhu Ngo RSS

    Need help and trick in cross table

    Mohammed Mukram

      Dears,

       

       

      i have one table which contains Student information along with their language and Marks in each subject.

       

      and one table with Parameter and Target .

      we need to check how many students achieved the target in %.

       

       

      you can find the attached excel file which contains 3 tabs

       

      1 tab ----> Data

       

      2 tab -----> Target

       

      3 tab ----- > Output result.

       

       

      The result should be in Pivot table with Total by Parameter.

        • Re: Need help and trick in cross table
          Nhu Ngo

          Is this what you're looking for

           

          Student_Tmp:

          LOAD

              "Student Name",

              "Student ID",

              "AGE",

              Gender,

              "Month",

              Language,

              Statistics,

              Science,

              Physics,

              English

          FROM [lib://Data/Table.xlsx]

          (ooxml, embedded labels, table is Sheet1);

           

           

          Student:

          Crosstable(Subject, Mark,6)

          LOAD *

          Resident Student_Tmp;

           

           

          DROP TABLE Student_Tmp;