Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Custom order of columns in Pivot
Summary
Custom order of columns in Pivot
Content
Hi,
Is it possible to modify (customize) the order in which columns in a Pivot are displayed?
I know we can do it A-Z or Z-A but for example I have 3 columns: Overtime, Standby & Urgent
I would like to order the columns:
Standby | Urgent | Overtime
Any pointers very welcomed!
Regards,
Pawel.
Answers
-
Hi Pawel - as far as I understand it, if you change the order of the columns in the data elements tab, it should change the order of the columns in the pivot. Please let me know if I've misunderstood your question though e.g.
vs 
0 -
Hi Pawel, thanks for replying.
I see what you mean now - and agree that this is a function that should be available, but I can't see this function at the moment.
However a consolatory fix could be this:
Create the following calculation
CASE WHEN Task Category= 'Standby' THEN 1 ELSE (CASE WHEN Task Category= 'Urgent' THEN 2 ELSE 3 END) END
or if there are more than 3 Task Categories
CASE WHEN Task Category= 'Standby' THEN 1 ELSE (CASE WHEN Task Category= 'Urgent' THEN 2 ELSE (CASE WHEN Task Category= 'Overtime' THEN 3 ELSE NULL END) END) END
Adding this new calculation as a column, and then sorting by this calculation A-Z.
I know this isn't *exactly* how you would have wanted to go about this, but it is a way that would work!
0 -
Hi,
Not exactly The issues is that I have only one column named: Task Category. Then, I have different values for it.... e.g. Standby, Overtime, Urgent, etc. So, what I'm looking for is how to sort the data in that column:
What I would like is to have Standby | Urgent | Overtime
Regards,
Pawel.
0 -
Nice idea!
When You mean to add it as a new column You mean during the Data Flow process right?
Agreed, definitely not a final solution but I'll test it. Thanks.
0 -
Great, let me know how it goes! I think it should work, but if not please let me know and i'll try to think of something else!
0 -
Nice Solution LSharm, but in this case, do we have to pull the second calculated column as well in the view?
What I meant is can we hide this calculated column or something? I do not want to pull this in my report or graph.
0