Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Turn rows in columns or filter columns by another column
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!
Answers
-
Use a pivot view instead of a table view.
0 -
Hi, I don't have measures , only attributes so pivot view not helping me
0 -
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.
0 -
0 -
Thanks!
0
