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.
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 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.
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.