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