How to pass the dynamic pivot table columns in APEX Interactive grid?
Hello,
I would like to pass the dynamic pivot table columns in APEX Interactive grid.
P1_PIVOT_DATA -> ('SEP-21' SEP,'OCT-21' OCT,null NOV,null DEC,null JAN,null FEB,null MAR...)
(sum(amount) for month IN &P1_PIVOT_DATA.) Piv
The above line is working fine in classic report, but not in interactive grid. How to pass the substitution string/bind variable in the Interactive grid pivot table columns?
Any help greatly appreciated.
Thanks