Need help and trick in cross table

[mdmukramali]

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.

[#2]

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;