This content has been marked as final. Show 8 replies
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.
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.
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.