How to stop cells merging in the Dashboard — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to stop cells merging in the Dashboard

Received Response
23
Views
3
Comments
3059347
3059347 Rank 1 - Community Starter


Hi There,

I just wonderered how I could stop this automically merging of cells.  I have taken a screenshot to show what it looks like when i export a report into Excel.

Merged cells Taleo.png

Is there a way i can edit this within the analysis/dashboard so that it gives me individual rows as opposed to merging all the same Dates/IDs together?

Many thanks

Dan

Answers

  • Sandeep Andhale
    Sandeep Andhale Rank 3 - Community Apprentice

    Hello

    I am facing same problem at the time of export analysis , i am also interested to see the solution .

    regards

    Sandeep

  • Hi Dan,

    Did you try to switch your columns from "suppress" to "repeat" ?

    Capture.PNG

    Doing this on all the columns where you want to remove the merging will repeat the value on each rows both in the dashboard and in the exported Excel.

  • 3059347
    3059347 Rank 1 - Community Starter

    Thanks for your response.  This is exactly what i was after.

    Brilliant!!