Forum Discussion
Pivot Table column label from horizontal to vertical
After pivot table and with grouping, some column labels have been showed but the caption is on the top. What i want is put the column header at the left of the row as vertical red text show as below....
Thanks for your reply. Not really like that, User requested to show the grouping by vertical, if in row then not meet their requirement.
george2175 Sorry, not sure I follow you here. Perhaps like this then? (see attached).
If not, perhaps you can mock-up a table and demonstrate how it should look like (what should be on the row headers and in what order, and what on the column headers.
What i want is display the column field caption & filter dropdown at the left, not at the top without changing the columns fields. I am not sure if it could be done or not.
george2175 I dare to say you can't do that.