Pivot Table Header and Formatting

Vismay Barot

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

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

@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

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

https://community.oracle.com/products/oracleanalytics/discussion/19462/left-right-center-justification-in-dv-tables-pivots

Mostafa Morsy-Oracle

@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

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 😊