Pivot table column heading
868910Sep 26 2011 — edited Sep 26 2011I 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