Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

How to create Header in Measure Label Column in Pivot Table ?

Received Response
141
Views
6
Comments
NagarajanK
NagarajanK Rank 1 - Community Starter
edited Aug 13, 2024 5:19PM in Oracle Analytics Forum

Hi Team,

I want Create - Measure Label Header -in Pivot Table

How to create this part?

Like this

Capture.PNG

Annotation 2020-03-02 185035.png

Thanks

Nagarajan K

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics & AI Lead

    Select "Format Heading" from the column edit options.  You can type in any heading you want, including a blank space.  Also specify the background color.

    pastedImage_0.png

  • NagarajanK
    NagarajanK Rank 1 - Community Starter

    Hi @ Jerry

    Thanks for the  response

    I am not sure -  This is Working 

    Like

    pastedImage_0.png

    I want get this option

    pastedImage_1.png

    Can you Explain Briefly and give Some Screen Shot

    I have one idea - but I don't know how to implement

    Can you Check : http://biztricz.blogspot.com/2011/07/obiee-10g-pivot-table-row-heading.html

    Thanks

    Nagarajan K

  • NagarajanK
    NagarajanK Rank 1 - Community Starter

    Hi @ Jerry

    Actually I have to use Oracle 12c

    Thanks

    Nagarajan K

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics & AI Lead

    Hi NagarajanK,

    Sorry that I misunderstood your question.  I don't have an answer for you, because that javascript solution that you cited doesn't work in 12C, and I'm not a js guy.  If you get a corrected script, you simply place it in a narrative view, check the "Contains HTML" box, and place it at the bottom of a compound view below your pivot table. I'm not aware of any OOTB solution. 

    Jerry

  • NagarajanK
    NagarajanK Rank 1 - Community Starter

    Hi @ Jerry

    If Possible Can you give some screenshot?

    Thanks

    Nagarajan K

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics & AI Lead

    If you have a javascript solution that works in 12C, on the Results tab, select the New View icon, then Other Views.

    You can use either the Narrative View or the Static Text View:

    pastedImage_1.png

    Place the js in the view and select the "Contains HTML Markup" box:

    pastedImage_0.png

    Place the new view at the bottom of a compound view that contains your pivot table.