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.

[Anonymous]

Hi Mohammed,

See attached.

Regards!