Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reg: Convert Columns into rows in the report

Received Response

51

Views

2

Comments

Newuser1

Newuser1 Rank 4 - Community Specialist

Jul 2, 2020 1:57PM edited Aug 13, 2024 5:17PM in Oracle Analytics Cloud and Server

Hi Team,

We have data in the below having only 2 columns status and total count

Status	Total Tick
DONE	50
WIP	25
Open	40

we have to show the data in the below format convert columns into rows. can some one suggest on this.

DONE	WIP	Open
50	25	40

Version using: OBIEE 12c

Regards,

0

Answers

Gianni Ceresa Mod

Jul 2, 2020 2:04PM

Answered the same thing 2 days ago: Turn rows in columns or filter columns by another column

0
Newuser1 Rank 4 - Community Specialist

Jul 2, 2020 3:24PM

Hi Gianni,

Thank you its working its working.

0