nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Turn rows in columns or filter columns by another column

Igor1188

Hi,

I have a data based on attributes:

Date Type Value

1/1/2020 a 10

1/2/2020 a 20

1/3/2020 b 30

I want to represent it that way

Date avalue bvalue

1/1/2020 10

1/2/2020 20

1/3/2020 30

How should I do it in OBIEE?

Thanks!

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Use a pivot view instead of a table view.

Igor1188

Hi, I don't have measures , only attributes so pivot view not helping me

Gianni Ceresa

Set an aggregation rule at the column level into the pivot view for "value" and it works.

If you know all the possible values of "type" you can create as many copies of "value" as needed and add inside a CASE WHEN condition to display the value only if "type" is = to every single value. With this you can keep your table view.

Gianni Ceresa

Igor1188

Thanks!