Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Grouping In OBIEE

3184221
Rank 3 - Community Apprentice
Hello All,
I have a requirement they want to see count of the columns.I am facing a issue to do it. Can anyone let me know how to do this requirement.
Sample Data:-
Status 2015 | Status 2016 | Status 2017 |
Service Part | Serial Part | TBD |
Service Part | Serial Part | TBD |
Service Part | Serial Part | Service Part |
Service Part | Serial Part | Serial Part |
TBD | Service Part | Serial Part |
Note :-Data above is conditional data and there is no unique column i can group by
Expected Data:-
Status 2015 | Status 2016 | Status 2017 |
Service Part | 4 | 1 | 1 |
Serial Part | 0 | 4 | 2 |
TBD | 1 | 0 | 0 |
Let me know your thoughts
Thanks
Uday
0
Answers
-
In column formula add something like Count("Column Name" by "Column Name") and also add the column. Then use pivot table. Example...
0 -
Thanks Its is working
0