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.
Is this what you're looking for
(ooxml, embedded labels, table is Sheet1);
DROP TABLE Student_Tmp;