Thank you Gurus for all the inputs!

Thank you for your inputs Sirs!

Hello Sir Christian, Thank you for your input. Yes I am more of a BI Publisher guy and it can be done using that tool.

Hello Sir Christian, The value of columnA is the one who will dictate what would be the column header name of columnB. Wherein columnA will be put in the 'Section' part in the pivot table: Also attaching the report layout I want to achieve. Thank you very much.

Hello Sir Christian, Thank you for your input sir. May I request please to kindly confirm if this requirement is feasible to do in analysis report (dynamic column heading base on a specific value)? Thank you again.

Hello, It will always have values (column_type) in that column since it is a required column. Thank you.

Hello Joel Acha, I am only using 1 column for this. I have a requirement that the column header name of this attribute should change to: 1. 'Units' if column_type = 'Units' or 2. 'Quantity' if column_type = 'Quantity'. Thank you for your reply.