In the toolbar--> Analysis-->Totals--> check the row grand totals instead of Column grand Totals.
I have my "row grand total" already checked.
I just want to rotate the row "grand total" label to horizontal, without affecting the category dimension values.
Hello JUDE WELLINGTON,
You need to create a calculated field that calculates the grand total total(sum(category)) and add it as a secondary Y axis by dragging it to the right of the chart pane until you see the dotted line.
Now there will be 2 sets of marks. Change the second one to line.
Is it what you were looking for?
I believe you can accomplish this without creating a calculated field.
When you right-click on the Grand Total label and select "Rotate Label", it will also rotate the category label, which is the problem.
To gain more granular control of alignment, right-click on the Grand Total label and select "Format". The format pane appears to the left, and you can adjust the Totals and Grand Totals alignment independent of the category label.
Hope this helps,