This discussion is archived
8 Replies Latest reply: Sep 26, 2011 12:44 PM by 868910 RSS

Pivot table column heading

868910 Newbie
Currently Being Moderated
I have a situation, its very hard to explain but I ll try my best.

I created a pivot table and this is what I did:

1) Under 'Rows', I brought in the 'Measure Labels' (not the actual measures, just the default Measure Labels)
2) Under 'Measures', I brought in all the columns (measures), I need to show. M1 to M15
3) Under 'Columns', I brought in one column that has to be displayed on top. C1

Now, the situation is, there would be a blank row beside C1 (i.e.,) first row of first column(1st record) is blank (this is by default and known behavior).
This table would look somewhat like an account statement/ledger.
My requirement is I need to display the heading of the first row (ie.,) heading for C1 in the first row, first column or anywhere beside the column (could be outside the table.)
The only thing is client needs to display the heading for that column.
Please help
  • 1. Re: Pivot table column heading
    Deepak Gupta Guru
    Currently Being Moderated
    Take help from here http://bintelligencegroup.wordpress.com/2010/09/08/changing-column-indent-color-in-pivot-tables/
  • 2. Re: Pivot table column heading
    868910 Newbie
    Currently Being Moderated
    Hi Deepak,
    Thanks for the reply.That was close. I should have been clearer. What I meant by heading was I wanted to display the actual column name.
    Example: I want to display the word 'Amount' at that place.

    OR may be you understood it right and showed me the right direction but I couldn't get the hint of it. From the link you sent, I think thats for formatting the background,etc..
    Please correct me if I m wrong.
  • 3. Re: Pivot table column heading
    Dpka Guru
    Currently Being Moderated
    Hi ,

    If my understanding is correct, you need to add a heading above the column.Something like this("Your Measure name" heading) as shown here,

    http://imageshack.us/photo/my-images/43/pivotheading.png/

    If yes , add a column to your answers request in the column formula(remove the existing formula) type in the heading, in my case i have typed 'Your Measure name'.Add this column section of your pivot view.This will solve your issue.

    Rgds,
    Dpka
  • 4. Re: Pivot table column heading
    868910 Newbie
    Currently Being Moderated
    You are close....I need the heading 'Your heading name' beside the current position of 'Your heading name'.

    Currently, its in 2nd column of 1st row right, I need it in 1st column of 1st row.
    Hope you got it.
  • 5. Re: Pivot table column heading
    868910 Newbie
    Currently Being Moderated
    This is my requirement---
    I got this online but it doesnt seem to work

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

    I added Narrative view/static view but it displays as a separate view beside the table and not in the 1st row.
  • 6. Re: Pivot table column heading
    868910 Newbie
    Currently Being Moderated
    The link I posted above worked fine.
    Thank you all for the help.
  • 7. Re: Pivot table column heading
    David_T Guru
    Currently Being Moderated
    Try this:

    To get a label above the column headings, you can try this in a pivot table:

    1) In the Criteria, get a CHAR column -- doesn't matter what -- click on the fx button and enter this:

    CASE WHEN 1=0 THEN tablename.columnname ELSE 'name of the label' END

    2) In your pivot table, drag alll your dimension columns into the "Measures" section of the pivot table and change the aggregation rule to "Max."

    3) Move the column from step on into the "Columns" section of the pivot table above the "Measure Labels."

    Now you will have a "label" column above the header columns as you requested, for a pivot table.
  • 8. Re: Pivot table column heading
    868910 Newbie
    Currently Being Moderated
    David,
    Thanks for responding but it worked for me when I followed the steps from the link I posted and that is the behavior I wanted.
    I tried yours as well but it is throwing an error.
    However, thanks for responding.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points