Related blog post has been drafted for menu drawer & hierarchical list template

Dynamic pivot

Closest I've got to showing only PRES/PRESIDENT columns is to include where clause embedding substutition string such as job = '&P39_CEO.', but returns ora-01403 in this demo, works in 4.2 
report error:
ORA-00904: "D"."PRES": invalid identifier

xml pivot
Job 36ANALYSTCLERKCLERK1MANAGERManagerPRESIDENTSALESMANTesterkjljljljlpmpruebatest
10 0001100200010
20 0120013200000
30 0020000000000
40 0100010000100
  1000000011001
1 - 5
Download
As described here by fac586 (Paul MacMillan)