Oracle Application Express (MOSC)

MOSC Banner

How to pass the dynamic pivot table columns in APEX Interactive grid?

edited Nov 12, 2021 4:18PM in Oracle Application Express (MOSC) Question

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center