OK, so you want totals in a pivot table. A relatively simple approach would be to add a ='Total' calculated dimension, go with indent mode on the style tab, and the swap your horizontal and vertical dimensions. On the down side, you have to swap your horizontal and vertical dimensions, so it doesn't look very good.
Aother approach is to add a value of 'Total' to the list of field values, then check for it and change the expression to match what you want in the chart. This seems more complicated than it should be, but keeps you from having to swap the horizontal and vertical dimensions. I'm hoping someone has a better solution than either of mine.
Hmm.. Pivot table seemed to be the simplest solution. Dragging the column header to the right should put the vertical to horizontal header. There is no need to get into complex aggregations etc, if a simple pivot could give you the totals.
