Pivot Table Header and Formatting

Vismay Barot · Aug 7, 2024 8:02PM

Greetings NSAW Community, I'm developing a Workbook Visualization and has selected Pivot (rather than a Table because need Merged Common Rows).

Now, I cannot see Headers (similar to what we see when we select Table Visualization), also, I cannot scroll down (I know there was data when I selected Table Visualization). Lastly, is there a possibility to center align rows (as supposed to top aligned currently).

Your help will be highly appreciated.

Thank You 😊

SteveF-Oracle · Aug 7, 2024 9:15PM

Hi @Vismay Barot

In your pivot table screenshot, you only have Attributes in the row. A pivot table expects columns and measures (values) .

When you say "(rather than a Table because need Merged Common Rows)"
Do you mean you need to blend data?
If so, you can always use a data flow to combine data into a new dataset to use in a table view.

Other comments, welcomed.

Mostafa Morsy-Oracle · Aug 8, 2024 6:30PM

@Vismay Barot

1- I found another workaround for your Scrolling issue and that you can select Container Scrolling into vertical and no need to add any measures columns.

Screenshot 2024-08-08 at 11.21.19 AM.png

Uploaded Aug 8, 2024305.35 KB

2- Regarding centerize Column Text this is already an idea lab please vote for it

left/right/center justification in DV Tables / Pivots

JeffK

Jul 28, 2023

I would like to be able to select the justification for columns of data, with these requirements:
Each column's justification property should be independent from the other columns
Data should be able to be aligned left/right/center regardless of data type (for example, numeric data could be left-aligned and text data could be right-aligned)
Each column heading should also have the option to be aligned left/right/center and this property should be independent from the data values in the same column.

Mostafa Morsy-Oracle · Aug 7, 2024 9:37PM

@Vismay Barot

I tested similar use case and I can see all columns can only display (Pivot Table) if size of columns or horizontal space does not fit all the columns also scrolling bar will not show up and you can use the mouse scroll to scroll up or scroll down if you add a measure to values Section

I can see you added 7 Text Columns and NO Measure Columns added which lead to scroll issue (This may be a Bug so recommend to file an SR)

for the Columns size you can use short names for columns or I will recommend to file an Idea lab https://community.oracle.com/products/oracleanalytics/categories/ideas

Vismay Barot · Aug 8, 2024 12:15PM

Hey @SteveF-Oracle and @Mostafa Morsy-Oracle, thank you both of you to recommend addition of measures, so I made a test-calculation and added under "Measure", and now I can scroll down till bottom and also able to see headers.

@SteveF-Oracle , to answer your question, I'm using "Pivot" rather than "Table" because, I wanted this kind of view wherein common rows are merged:

I cannot do the same in "Table" Visualization, right? Please correct me if I'm wrong.

Lastly, is there any possibility to Center Align Rows in Pivot Visualization?

Your comments/suggestions will be very helpful.

Thank You in advanced 😊

Oracle Analytics Cloud and Server

Welcome!

Quick Links

Categories

Pivot Table Header and Formatting

Best Answers

left/right/center justification in DV Tables / Pivots

Answers

Welcome!