Help in script

[Anonymous]

Hi All,

below is my pivot data.

hierarchy is Org name->VP->staff->Manager->student

In pivot table(qliksense) i want  the name shields to be displayed only once even though he is part of other columns

Below is my load script.

Table1:

Orgname,  VP, Student_no

from ..

left keep(Table1)

Table2

Manager,Student ,Student_no,Staff

from...

Thanks,

Raghav