This content has been marked as final. Show 8 replies
Take help from here http://bintelligencegroup.wordpress.com/2010/09/08/changing-column-indent-color-in-pivot-tables/1 person found this helpful
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.
Hi ,1 person found this helpful
If my understanding is correct, you need to add a heading above the column.Something like this("Your Measure name" heading) as shown here,
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.
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.
This is my requirement---
I got this online but it doesnt seem to work
I added Narrative view/static view but it displays as a separate view beside the table and not in the 1st row.
The link I posted above worked fine.
Thank you all for the help.
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.
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.